Search results

When I try to follow Access Help instructions for creating a Union Query, I get the following instructions: 1. In the Database window, click Queries under Objects, and then click New on the Database window toolbar. 2. In the New Query dialog box, click Design View, and then click OK. 3. Without...

:rolleyes: I want to create subforms for two forms. Whatever works for one will work for the other since the parent forms represent Purchases and Sales (two sides of the same coin). I want the subforms to show Current Inventory by location. In order to do this I’m pretty sure I must create...

I have four (4) Combo Boxes in a form. Two (2) of them, Item ID and Location ID place the value selected into the Purchases Table exactly as I would like. The other two (2) Combo Boxes return the correct value in the form when selected but place incorrect values into the Purchases Table as...

I am trying to use the DLookup Function on a form. I want to input the customer’s name from a combo box and have the correct customer number returned in an adjacent bound text control. The form (an invoice) is based on the Sales table. The customer number is in my Customers table. I think that...

I am trying to achieve the following result in a form to record purchases: 1. Action: Enter an Item ID in a form. 2. Result: Have the corresponding Item Name generated for me. I do not know the correct term for this function so Help can’t lead me to the correct solution. Can someone tell me...