Nursery Ed
New member
- Local time
- Today, 14:17
- Joined
- May 1, 2004
- Messages
- 7
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 follows:
When I select Item Name and choose it places Item ID in the table.
When I select Location Name and choose it places the Location ID in the table.
On the first screen of the wizard, I selected the first option “I want the combo box to look up the values in a table or query”. From the second screen I selected the correct table where these values are stored (Items Table for the first and Locations Table for the second). From the third and forth screens I selected the correct values. I tried this both ways selecting only one value to list and selecting both values and I’ve tried it with “hide key column” and not hiding the key column.
The correct values I need to store in the table appear when I select them. What could I be doing wrong for two (2) of the combo boxes to work the way I intend and two (2) that won’t?
My first choice was to create a combo box to select an item number and have the item name appear in a text box (the result you get in QuickBooks or Peachtree) but I haven’t a clue how this works.
When I select Item Name and choose it places Item ID in the table.
When I select Location Name and choose it places the Location ID in the table.
On the first screen of the wizard, I selected the first option “I want the combo box to look up the values in a table or query”. From the second screen I selected the correct table where these values are stored (Items Table for the first and Locations Table for the second). From the third and forth screens I selected the correct values. I tried this both ways selecting only one value to list and selecting both values and I’ve tried it with “hide key column” and not hiding the key column.
The correct values I need to store in the table appear when I select them. What could I be doing wrong for two (2) of the combo boxes to work the way I intend and two (2) that won’t?
My first choice was to create a combo box to select an item number and have the item name appear in a text box (the result you get in QuickBooks or Peachtree) but I haven’t a clue how this works.
