Rerun a query after update

[schwabe]

Hello all,



I've set up a "query by form" and now I'm having an issue that I need to press refresh all after the update.

Some more details:
I have set up a form with two subforms. Each subfom contains a multiple items form and on the main form I have two comboboxes to select customer and project. The subforms then give me some information just on the customer and project.

I have set up the query by form by using a filter like [forms]![mainform].[cbocustomer] & "*" and [forms]![cboproject] &"*", respecively.

Everything works nicely, but I have to press "refresh all", once I've changed my choice of custoemr and/or project?

Is there an easy way to do the refresh all in VBA? I might also just refresh the two queries. (The Me.Requery does not work).

Thanks!

[pbaldy]

The Requery should work, but it sounds like you'd need to requery the subforms, not the main form (or in addition to the main form).

[schwabe]

That solved the problem instead of Me I had to give the subforms...

Thanks again!

[pbaldy]

No problem! It would be nice if the Me.Requery also did any child objects like a subform, but alas, not the case.