M
mattc66 via AccessMonster.com
I am using a command button to copy data from one subform1 to another
subform2. Once the data had been copied to subform2, I'd like to have the
next record in Subform2 ready to accept data.
What happens is if I click the command button in subform1 it copies the data
to the first record in subform2 unless I manually select the next record in
subform2.
Subform1 is a Continuous Form
Subform2 is a Datasheet Form
Both of these subforms are contained in a MainForm.
I hope this make sence.
Private Sub cmdLinkData_Click()
Forms!mainform!subform.Form.fld1 = Me.fld1
Forms!mainform!subform.Form.fld2 = Me.fld2
End Sub
The purpose of this is to link 2 tables into a 3rd table.
We need to link our sales orders to incoming purchase orders. So the planner
clicks a button in the sales order subform and a button in the purchase order
subform and the two are linked in a 3rd table, by the Item#, Order Line#,
Order# --> linked to Item#, PO Line#, Purchase Order#.
Thanks
Matt
subform2. Once the data had been copied to subform2, I'd like to have the
next record in Subform2 ready to accept data.
What happens is if I click the command button in subform1 it copies the data
to the first record in subform2 unless I manually select the next record in
subform2.
Subform1 is a Continuous Form
Subform2 is a Datasheet Form
Both of these subforms are contained in a MainForm.
I hope this make sence.
Private Sub cmdLinkData_Click()
Forms!mainform!subform.Form.fld1 = Me.fld1
Forms!mainform!subform.Form.fld2 = Me.fld2
End Sub
The purpose of this is to link 2 tables into a 3rd table.
We need to link our sales orders to incoming purchase orders. So the planner
clicks a button in the sales order subform and a button in the purchase order
subform and the two are linked in a 3rd table, by the Item#, Order Line#,
Order# --> linked to Item#, PO Line#, Purchase Order#.
Thanks
Matt