Web Development

General discussion

Gravatar
0 Votes
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.

Thread display: Collapse - | Expand +

All Comments

gravatar
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>

gravatar
Collapse -

by jallen In reply to Combo Box data

Forms!MyForm!MyComboBox.Column(2).

Note that the columns start at 0.

gravatar
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

Start or search

Related Discussions

Related Forums