Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Duplicating records in subform

Status
Not open for further replies.
achau

achau

Technical User
Apr 16, 2001
34
GB
How can I copy all the related records in a subform when I create a new record in the mainform?

I have created a button in the mainform so that when it's pressed, the data in the mainform are copied into a new record (same data table), with one of the keys "versionid" linking the mainform and subform (the parent and child tables) increasing by 1. However, I cannot figure out how to copy all the related data in the subform at the same time.

Any help appreciated.

Al
 
Status
Not open for further replies.

Similar threads

Kennelbloke
  • Locked
  • Solved
Subform not updating in parent form
Replies
10
Views
505
Kennelbloke
Kennelbloke
caykamanj1966
  • Locked
  • Question
Duplicate Records in DataSheet View
Replies
5
Views
444
Andrzejek
Andrzejek
Bubba002
  • Locked
  • Question
Pass a subform fieldname-ID as a string variable in CF expression
2 3
Replies
50
Views
2K
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Use Crosstab query in subform
Replies
9
Views
346
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Subform not updating 1
Replies
12
Views
472
TrekBiker
TrekBiker

Part and Inventory Search

Sponsor

Back
Top