hi,<br>my problem is that I can't copy records of subforms...<br>I have a mainform with several subforms, the main form has one duplication command (built by the command button wizard), by clicking this button I want to copy all the displayed information (of the main and subform) and put it into the empty last record. For some reasons it's just taking the informations of the mainform...<br>who can help me?<br>thanks...
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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
copy records of subforms
- Thread starter dvoegele
- Start date
Well a subform is a separate entity<br>It is a regular form just put on another form thus making is a subform.<br>So to add data from several places you need to get the recordset of the subform and deliberately put it in the new record. Like so:<br>Note: put this code after the code Access wrote<br><br>Me![Field On Main form] = Me![Subform name].Form![Field on subform]<br><br>do this for each field you want to make <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question