How to refresh/requery a subform to show newly added record?
I have a form with an unbound combo box that is used to filter a subform. When I add a record in the subform and hit enter, I'd like the subform to show the new record automatically.
Right now I can only see the new record if I go back to the main form and select an option from the combo box again.
I've tried, in the AfterUpdate event of a control on the subform:
Me. Dirty = false
Also tried some longer versions of requery specifying the names of the forms: i.e. Forms!mainformname!subformname.Form.Requery