Saving Subform Record

[Jim Franklin]

Hi,

This may be a really silly one, but....

How do I save a record on a subform using VBA code. I have a tiny snippet of
code, which changes a couple of fields as follows:

dim sfrm1 as SubForm
Set sfrm1 = me!Subformcontrolname

sfrm1!Field1 = X
sfrm1!Field2 = Y

I want to use

Docmd.RunCommand acCmdSaveRecord

but this will only update my main form.

Thanks for any help!!
Jim

 

[Allen Browne]

Set the Dirty property of the form in the subform control:
sfrm.Form.Dirty = False