I have a combo box that has a three field query, the bound field is field 1, Because field 1 is a concatanated field (Last Name, First Name) I use that to look up the user information. However if there are two persons with the same last and first name I want to use the birthdate as the next lookup. Is there anyway in VBA to find that third column in my combo box query? Thanks for any help.
This conversation is currently closed to new comments.
and if there exists a person with the same name and dob?
I your table provides an id-field (primary key) I would add this as the first field in your query and make it the bound field with a width of 0 in the Listbox/combobox.
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Combo Box data
Thanks for any help.