Recent content by Nursery Ed

Thank You Neil I posted a question on Queries. I am trying to follow the steps in Access Help to try your suggestion but it's asking me to point to SQL Specific and I'm finding my only choice is an SQL button which, when I click on it, defaults to "SELECT". When I clarify what I'm doing wrong...

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...

Thank You Len Thank you Len. I did just that and it solved my problem. Apparently even if you select only one column to display (using the wizard), the wizard brings in both (in the case of item number and item name) and stores (by default) the first value. I changed the default value from...

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...