General discussion

Locked

Combo Box data

By CD Tom ·
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.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by Karpi In reply to Combo Box data

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
<fluctuat nec mergitur>

Collapse -

by jallen In reply to Combo Box data

Forms!MyForm!MyComboBox.Column(2).

Note that the columns start at 0.

Collapse -

by dhz920 In reply to Combo Box data

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

Back to Web Development Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums