Forms / subforms - queries and tables

[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

 

[Guest]

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"