nosferatu26
Registered User.
- Local time
- Yesterday, 23:46
- Joined
- Jul 13, 2015
- Messages
- 57
Hi, I am having a problem displaying certain data in my listbox in a form.
The listbox displays several fields, one of them is "Part Number" and sometimes that part number is going to be "TBD" depending on the item. When that is the case I want to display the part version(another field that isnt displayed anywhere else in the listbox) along side of it but only for items with a value of TBD, not for any others. Is this possible?
I was playing with the listbox queries for that field in the design view but i could only get the part version to display for every item by concatinating it in with code like "PN: Part_Number & " Version: " & Part_Version".
if anyone can help me with this it would greatly be appreciated.
The listbox displays several fields, one of them is "Part Number" and sometimes that part number is going to be "TBD" depending on the item. When that is the case I want to display the part version(another field that isnt displayed anywhere else in the listbox) along side of it but only for items with a value of TBD, not for any others. Is this possible?
I was playing with the listbox queries for that field in the design view but i could only get the part version to display for every item by concatinating it in with code like "PN: Part_Number & " Version: " & Part_Version".
if anyone can help me with this it would greatly be appreciated.
