Jonny45wakey
Member
- Local time
- Today, 16:36
- Joined
- May 4, 2020
- Messages
- 40
Hi I'm hoping someone can assist me please?
I have a table called tblRouteCards which contains the following fields:-
Job_Number
Order_Number
I use a form called frmRoutings to populate the table and have a cmd button to open a form called frmBILLOFMATERIALS which uses the following VBA to open the form with matching Job_Numbers
Private Sub Command203_Click()
If Me.Dirty Then
Me.Dirty = False
End If
DoCmd.OpenForm "frmBILLOFMATERIALS", , , "[Job_Number]='" & Me![Job_Number] & "'"
'DoCmd.Close acForm, "frmBOM1"
End Sub
This works fine upto this point and the form frmBILLOFMATERIALS opens displaying the above data.
What i would like to do is on the form frmBILLOFMATERIALS is have another CMD button to insert the values from Job_Number & Order_Number and a textbox called PtNo1 into tblBOM
Ive tried the INSERT INTO SQL but without success
Any help appreciated
Thanks
jonny
I have a table called tblRouteCards which contains the following fields:-
Job_Number
Order_Number
I use a form called frmRoutings to populate the table and have a cmd button to open a form called frmBILLOFMATERIALS which uses the following VBA to open the form with matching Job_Numbers
Private Sub Command203_Click()
If Me.Dirty Then
Me.Dirty = False
End If
DoCmd.OpenForm "frmBILLOFMATERIALS", , , "[Job_Number]='" & Me![Job_Number] & "'"
'DoCmd.Close acForm, "frmBOM1"
End Sub
This works fine upto this point and the form frmBILLOFMATERIALS opens displaying the above data.
What i would like to do is on the form frmBILLOFMATERIALS is have another CMD button to insert the values from Job_Number & Order_Number and a textbox called PtNo1 into tblBOM
Ive tried the INSERT INTO SQL but without success
Any help appreciated
Thanks
jonny