Search results

Hey all, Just wondering how I can have a drop down box and once and option is selected it autofills other fields? Always best with an example of what I am looking for. . . I have 3 tables Customers Invoice Payment I have a payment form and use a drop down to select the Invoice...

Is there an easy way to add a table to the record source to a Form that is already created? In my example I have a form that uses all the info from the "Invoices" table. This table has the field "Customer ID" What I want to do is use the customer ID to get the customer name from the...

Hey All , An easy one I am sure. I have a form "Invoice" with a sub form "Payments" I dont know how I did it but I made the entire form navigate by the sub form. ( this means when I click "next" for the next record it is scrolling through the Payments ID's.) Not ever Invocie has a...

Hey All, New to access here and I have picked up most of the stuff myself but am having problems with 1 thing for the last 3 days. I am creating a basic system with 3 tables Customers, Invoices, Payments. I am creating a form that is to take in the details of a new Invoice. I am using the...