Change to underlying tables not reflected in a query or form?

#1

It seem I have to close a Query/Form and then reopen it to get it to reflect
changes in underlying tables.

Is there a less combersome way?

#2

"me" <Darcy (AT) 0S0i0t0e0w0a0r0e0 (DOT) com> wrote

Quote:

It seem I have to close a Query/Form and then reopen it to get it to reflect
changes in underlying tables.

Is there a less combersome way?

Add a button on your form and put in the following code:

Docmd.requery

Regards,

Ray

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

comp.database.ms-access comp.database.ms-access