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

M

me

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?
 
R

Ray

me said:
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?
Click to expand...

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

Docmd.requery


Regards,

Ray
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append Crosstab Query to Existing Table 0
auto query update? 9
Adding data to MS Access from csv file 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Going Crazy! Form Datasheet does not reflect changes to SQL query 4
Trouble Opening Outlook 365 1
sqlite-odbc write conflict 2
Getting a formula to reflect added columns 10

Top