Combo Box Problems

[blanch2010]

I have created a combo box that uses a query to select a record.

In this combo box is the client first, last, & middle names. Also the
client address city & address number.

Some clients have multiple property addresses and city related to there names.

If I chose a name from the list of names & addresses it will pull up that
record in the form.

My problem is if there are two last names that are the same but the
addresses are different the combo box will only allow me to select the first
last name in this instance Johnson in Riverside but will not allow me to
select Johnson in Anaheim.

How do I or can I give the query a criteria to pass by and select the 2nd
last name & city?

I hope I'm explaining myself correctly.

Thanks
Don

 

[KARL DEWEY]

Post the SQL of the query used for the combo box.

 

[Gina Whipp]

blanch2010,

Since none of those fields are unique, is there a field in the table where
you get the information from that is unique?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm