Web Development

Ask something
Discussion Locked

Combo Box data

0 helpful
3 replies

by cd tom

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

3 replies

by karpi

Hello,

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.

HTH Karpi

by dhz920

I believe the combo box fields can be referred to as an array cbobox(3) etc.

This discussion is closed to new replies.