Refresh All

[gg80]

Must be simple, but even after googling and experimenting, I can't seem to find a way to duplicate the "refresh all' command on the menu bar with code. Can someone please tell me how?

The form is a single form with a subform. The code I am running before refresh all requirement activates a couple of append queries that duplicate the existing data in the parent and child forms.,



I would like the user to have the duplicate immediately available. I am using both A2007 and A2003.

[Robeen]

Try 'Requery'.

[gg80]

Robeen-thanks very much. I had thought that requery was meant to act on query sourced forms whereas this form is sourced to tables. Thanks again-love this site.

[Robeen]

Happy to help!