Originally Posted by
June7
AFAIK, Access macros and queries cannot see combo or list box columns, only the value in the box. One option:
Have a textbox pull info from the listbox: =Listboxname & " " & Listboxname.Column(1)
Have a field in query that concatenates the two fields: FullName: [Last Or Business] & " " & [First]
The where clause: "[FullName] ='" & textboxname & "'"
This assumes listbox first column is not actually a hidden column containing a key.
This would be much simpler if you used unique identifier such as autonumber PK/FK in criteria instead of descriptive text.