spectraflame
Well-known Member
- Joined
- Dec 18, 2002
- Messages
- 830
- Office Version
- 365
- Platform
- Windows
I have a combo box that lists all part numbers in our inventory. Since most of our people know the numbers by memory, it is only listing the numbers. I would like to go a head and display the item desription next to the part number in a text box just for visual purposes. I do not need to store this information in a table.
The combo box is based on a query for all part numbers based on department. Is it possible to use something like VLOOKUP to look up the part number in the query and return the description in the unbound text box?
Matthew
The combo box is based on a query for all part numbers based on department. Is it possible to use something like VLOOKUP to look up the part number in the query and return the description in the unbound text box?
Matthew