Requery from navigation form

[PrimaryKey]

Hello All,

I have an Orders form that uses a popup to allow users to add items to the order. When clicking the "Save & Close" button, I have a VBA event that requeries the OrderItems subform on the Orders main form so that the list of products added to the order is refreshed.



A few days ago I added a main navigation form and added all the forms to the main navigation, and now the requery stopped working. Do I need to include the navigation form in the form-path for the requery action? Such as: Forms!NavForm.NavSubform.OrderForm.OrderItemsSubfo rm.Form.Requery

[Minty]

Yes - but be aware that the forms on the inbuilt navigation form are loaded as sub forms, and are only loaded on demand, so they aren't there if not the current form.
It's why a lot of us don't use the inbuilt navigation form, as they are a pain to reference,

[CJ_London]

Do I need to include the navigation form in the form-path for the requery action? Such as: Forms!NavForm.NavSubform.OrderForm.OrderItemsSubfo rm.Form.Requery

depends on where your code is. If it is in the orderform, then you can just use

me.OrderItemsSubform.requery