Add record to a subform

A

Arta

All,

I can't add multiple records to a subform! whenever I try to add a second
record the message for the primary key and duplicated values shows up!

Please help!

Thanks,

Arta
 
A

Allen Browne

If you are trying to add them programmatically, AddNew to the RecordsetClone
of the form.

Example:
With Me.[NameOfYourSubformHere].Form.RecordsetClone
.AddNew
.SomeField = "Hello"
.AnotherField = 99
.MyDateField = #1/1/2005#
.Update
End With
 
Top