Update Main Form from Button on sub-form

[puforee]

I have a db that contains a main form with one sub-form. The main form shows a customer that requires periodic audits. The sub-form shows data from each audit.

After an audit is complete and data is entered in the sub-form I have a button, on the sub-form, that updates the "Last Audit" field in the table that drives the Main form. But I now need the Main Form or the "Last Audit" control to be refreshed or re-queried to show the updated value. I would like the Main Form to show the same record after the refresh or re-query.

I know I should be able to do this but.....

Help please.

John

 

[puforee]

Ahhh....I worked it out and all is good.

John

 

[Darrylles]

puforee

This forum is for the benefit of everyone - not just for YOUR individual problem.

You raising a question, then saying "I fixed it" - doesn't help anyone.
If I search for "Update Main Form from Button on sub-form", YOUR post comes up in the results.
I drill into it, and the solution is: "I fixed it" - it doesn't help anyone.

What WAS your 'fix' - please share!

ATB,

Darrylle