How do i update or refresh my forms after an update query?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have added a number of records to a table with an update query, but i can't
seem to get my form to reflect those changes. How do i update or refresh my
form so that i can access the new records in my adjoining table?
 
Thanks Yanick,

I'm new to using Access, so i'm not sure what "me.refresh" means exactly.
i've tried the refresh fuction under "records" on the forms toolbar, but it
doesn't add the new records from my updating table. any suggestions?
 
You need to add "me.refresh" in the event used to save your record. It is VBA
code.

I guess you probably save new record by pressing a button on a form. If you
right click on this button and go to properties in the "event tab", you
should see the "On Click" event. Access VBA and add "me.refresh" after the
line where save record is done.

I am not sure if it is the best solution but it should work fine.
 
Back
Top