Is there VB code for the function SHIFT + F9 to refresh a form? I have a form designed for sorting (searching) invoices where the user can tix boxes next to fields they want to search by, and enter data in them. Then the search button is pressed, which basically only needs to update the subform which uses a query as its data source.

The query checks the tick boxes and unbound fields in the parent form and that is working fine, but i can't get the subform to update with the resultant records! If I click on the subform, and on the access menu click Records > refresh, nothing happens. However SHIFT+F9 works. I need to have clicked on the subform first, assumedly so it is in focus, so what code would be a good alternative to this manual solution?

I've tried:
Forms("frmFindInvoices").refresh

and

Forms("frmFindInvoices").requery

- both after setting the focus to the subform.

Running out of ideas! any help appreciated! :)

Hmm... you know what, never mind. Somehow, this now works :)