Forms / subforms - queries and tables

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

Guest

I have a table which is changing a value in a Query.
The table as well as the Query (in Datasheet view) are subforms in a form.
If I alter the table, the query gets altered as well – but it’s not shown
immediately on the form. If I close the form and open it again than I can see
the new value.
I would like that I can see the “queryform†value if I alter the value in
the “tableformâ€.
Is that possible with a command button which I have to push after altering
the table?
Thanks
Klaus
 
You can either do that on a button or on the After Update of the field you
are changing.

Use the following code:
DoCmd.Requery "sfrmSubFormName"
 
Back
Top