Updating a form in access

[GGrieve]

I have a form that automatically appends a record to a different form if criteria is reached, As all forms are on a tab control How do I get the appended form to update with new record on click of tab. Many Thanks

 

[speakers_86]

In the tab properties, use the on click event to run code something like this

docmd.OpenQuery(YourQueryNameHere,acViewNormal,,)