Search results

  1. S

    Replacing Excel form with Access so we can capture the data

    Yes the line items table is displayed as a sub form on the main form. Which i want to auto populate the line items based on the product field selected on the main form.
  2. S

    Replacing Excel form with Access so we can capture the data

    Thanks everyone. The area that I am struggling with is getting the invoice line items to automatically populate. Invoice header contains a Product Code: I then want to populate the invoice line item table automatically ready to verification. Eg, Product A is selected on the Invoice Header...
  3. S

    Replacing Excel form with Access so we can capture the data

    Hi All, I am hoping that you can help me. I've been using access for years but after a long break I'm having trouble breaking back into it. What I'm trying to achieve is create a database whereby an 'Invoice' document will be produced but also the information is saved in an invoice table...
Top Bottom