Derek Girven
New member
- Local time
- Today, 04:34
- Joined
- Feb 13, 2020
- Messages
- 10
Hi,
I am trying to pass the invoice number of my form to a table where the criteria is MakeInvoice is yes.
So all the records in the Subform of this form will have this invoice number.
I hope that makes sense ?
Private Sub Invoice_Number_AfterUpdate()
Dim strSQL As String
strSQL "INSERT INTO tblOrderFormDetails ( InvoiceNo )SELECT qryInvoiceDetails.InvoiceNo FROM qryInvoiceDetails WHERE (((qryInvoiceDetails.MakeInvoice)=Yes));"
DoCmd.RunSQL
End Sub
I am trying to pass the invoice number of my form to a table where the criteria is MakeInvoice is yes.
So all the records in the Subform of this form will have this invoice number.
I hope that makes sense ?
Private Sub Invoice_Number_AfterUpdate()
Dim strSQL As String
strSQL "INSERT INTO tblOrderFormDetails ( InvoiceNo )SELECT qryInvoiceDetails.InvoiceNo FROM qryInvoiceDetails WHERE (((qryInvoiceDetails.MakeInvoice)=Yes));"
DoCmd.RunSQL
End Sub