Data Capture

[jbento]

I can copy data from a subform with the following:

Private Sub Command2_Click()
frm_subform1.SetFocus
DoCmd.RunCommand acCmdSelectAllRecords
DoCmd.RunCommand acCmdCopy
End Sub

I want to copy 2 subforms at the same time, and I don't know how. I have tried the following and it doesn't work:

Private Sub Command2_Click()
[frm_subform1].SetFocus![frm_subform2].SetFocus
DoCmd.RunCommand acCmdSelectAllRecords
DoCmd.RunCommand acCmdCopy
End Sub

Can someone please help me with this?

Any help would greatly be appreciated.

Thanks in advance.


Jerome Benton
JERPAT Web Designs

http://www.jerpat.org

GOD Is Good All The Time!!!

 

[jimb0ne]

why don't you copy one form then the next rather than trying to do them at the same time?

 

[jbento]

I really wanted to do this at one time, because I actually have 7 subforms on the mainform.

Can this be done?

Jerome Benton
JERPAT Web Designs

http://www.jerpat.org

GOD Is Good All The Time!!!

 

[jimb0ne]

you could use a for each loop and loop through the forms, and then copy them one at a time. It would save all the extra lines of code. Other than that..... someone more 1337 than me needs to figure that out.