I got to somehow enter a Vendor Name and Store Number only once on a form and move this same same Vendor Name and Store Number throughout the order form.
I will have a form come up for the user to enter a Vendor Name and Store Number. The Order Cases button is selected. An Order form loads. The user starts entering data for the order. I need for all orders with this same Vendor Name and store number to appear in
another subform of the form.
How can this be done in Access 2007? Please see my database. I have set up database where the person signed in will only see their orders they put in and not someone elses.
I will have six users entering data into the system.