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!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to duplicate record with subform contents
- Thread starter Tash
- Start date
It is probably best to create two append queries, one for the main form and one for the subform. You can either build the SQL string in code, or reference the ID field on the form in the queries. Make sure that you do not include the autonumber, if one exists, in the append.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
