refresh data

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

Guest

I have a form that has a couple sub forms inside it. when I up date one of
the databases, it does not show up in the other sub forms until i hit refresh
data or move from record to record or open / clode the form. Is the an
option or code to refresh data links after each record entry?

CB
 
First of all, I am not the VBA user, so I cannot suggest you with the VBA
code. However, you could use macro to accomplish the same thing. In macro,
assign the macro name, and select Requery in the macro command list. Attach
this macro name in the fields you input the new data, so after you finish
update, this macro will run to update and appear in the subform.
 
You must log in or register to reply here.

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

Access Form Refresh 1
Access Sub form opens before the main form in MS Access 0
Need combo box to refresh when moving to new record 2017 1
Refresh data in sub forms when one sub form is edited 4
Refreshing filter on Subform in Access 2010 0
Refresh/OnCurrent Questions 3
Auto refresh linked excel table from access database 1
Edited data record to be inserted as a new data record under the same PO number in Microsoft Access 0

Back
Top