saving data in a subform 1

[joeblow3]

Hi:

I am having a problem with saving data entered in a sub-form.

I put a command button on the sub-form and used the wizard as follows:
I chose "Record Operations", and "Save Record".

It filled in code:
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

But this does not work! my sub-form is to save in a different table than the main form's table.

The two forms are ofcourse linked by a field common to both.(Both the Child and Master fields
of the sub-form say "Event_id" for example).

Thanks in advance.

 

[dhookom]

Why do you think you need to force a save? This generally happens automatically when the form loses focus. If your code is running in the main form, it will save the record in your main form.

You may be able to add code like:

Me.sfrmCtrlName.Form.Dirty = False

Duane
Hook'D on Access
MS Access MVP

 

[joeblow3]

many thanks for your help.