Save record

[Angus]

How can I save a record on a hidden form?

The hidden form has an attached table and is in single record view. One of
the fields on the form is updated using VBA on the active form.

I want to then save the changes to the activ record in the hidden form.

Thanks.

 

[Allen Browne]

If the form is named "Form2", you can save it's record like this:
Forms![Form2].Dirty = False