Recent content by Derek Girven

  1. D

    Passing Invoice number

    Thanks
  2. D

    Passing Invoice number

    But I am not saving it twice !
  3. D

    Passing Invoice number

    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.
  4. D

    Passing Invoice number

    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 ?
  5. D

    Passing Invoice number

    Linking Subforms to an Unbound Control(s) on the Main (Parent) Form If the Invoice number is unbound on the main Page
  6. D

    Passing Invoice number

    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 ?
  7. D

    Passing Invoice number

    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...
  8. D

    Passing Invoice number

    Dear Namliam I respect that is what you do but that is not what I want to achieve. so if you can help great ...!!
  9. D

    Passing Invoice number

    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?
  10. D

    Passing Invoice number

    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...
Top Bottom