I have a production form that work off a query of Invoiced so If its no it shows up , when invoiced it goes out of production , the invoice list works off these,I hope that makes sense , I can attach if you have free time.
I have many orders in production and as I finish and ship what is ready on a friday , not all of that order may be complete so I invoice part order if that makes sense ?
thanks for tip toes ..so the query may have a problem. I just went to your access diva page I see you had an Unbound control to subform tip would that work ?
I have a query that populates the subform working off a check box (make Invoice) .. I looked at the form /subform they are not linked by Invoice number as that seemed to stop the query working to populate the subform. I just want to save the invoice number for those records in that form. I have...
I Have a link the subform and the main form. but I need it to pass the invoice number then to all the records in that form subform (I have a invoice number column in the subform).I just need the code or an idea how to pass that number then .can you help?
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...