Add record to a subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

primary key - concatenated or autonumber? 6
Same record/Primary key in multiple tables 0
Copy header and related records 1
Subform record coordination 2
How to refresh a single record in a datasheet subform? 1
Deleting records in a subform of a subform 2
Index/Primary Key Error Handler 1
Data entry creating duplicate rows in table 3

Back
Top