I have a bombo box that selects product details, once the details are selected a click button transfers the data from one form to another.
The problem i have is that when it transfers the data it keeps copying over the same record. What i need is it to appear as a new record in the subform i am transferring the data to.
Is there a function to do this? Here is my code so far.
Code:
I know you can do 'RunCommand acCmdRecordsGotoNew', i am not sure where to place it. I tried under this line.
But it just makes the form i am transferrng the data from go to a new record. Any help would be rgeat.
Thanks in advance!
The problem i have is that when it transfers the data it keeps copying over the same record. What i need is it to appear as a new record in the subform i am transferring the data to.
Is there a function to do this? Here is my code so far.
Code:
Code:
Private Sub AddtoOrder_Click()
On Error GoTo Err_AddtoOrder_Click
Me.Parent.F_Order_line_subform.Form.ProductID = Me.ProductID
Exit_AddtoOrder_Click:
Exit Sub
Err_AddtoOrder_Click:
MsgBox Err.Description
Resume Exit_AddtoOrder_Click
End Sub
I know you can do 'RunCommand acCmdRecordsGotoNew', i am not sure where to place it. I tried under this line.
Code:
Me.Parent.F_Order_line_subform.Form.ProductID = Me.ProductID
But it just makes the form i am transferrng the data from go to a new record. Any help would be rgeat.
Thanks in advance!