I need help with my purchases form. I need to be able to insert a quantity and a location for items received when you press the button on the receive button on the subform of purchases. I can not enter a value in the first four boxes until after I enter in the location, then it acts as if there is a new location and blanks out those boxes. I have uploaded my database.

Any help would be appreciated thanks.

The problem here is that the Purchases Received form is bound to a query that joins several tables. You don't need Shelf, Rack and Slot to be selected. They just need to select the LocationID as a FK and you can fill in the other 3 using unbound controls.

You are trying to update two tables in the query that is the Record Source for the form.... You do not have your data normalized as Location should not be a 'lookup' but a related table to PurchasesReceived. At least that is how I read your data. Also, inventory control using Access is not for the faint of heart and you must be sure you know how to set up your structure if you are going to keep track of inventory.

Just my 3 cents worth....

Jack