Update automatically

[grenee]

Good day All.

I am on a form "Claims". I leave to add a record to another form "Instructor". When I return to "Claims" the new record added to "Instructor" does not appear in "Claims". It will appear, however, if the Claims form is closed and reopened.

Is there a macro that can allow the Claims form to update without closure?

Thanks

 

[pbaldy]

Yes, Requery.

 

[grenee]

Thanks.
I suspected it was requery. However my form consist of a form that contains a liked subform; so then what event should be used: on load on current etc.

I want all the form requeried.

 

[pbaldy]

One option is the close event of the Instructor form. If the Claims form might not be open, you can test with IsLoaded first.