Combo Box Question

[sinisterfrog]

I am attempting to make a form that will serve as a data entry form for new customers as well as serve as a customer lookup form.

So my source data is pulling directly from a Customer table (name/company/addresses/etc). I have made a combo box using the wizard to "find a record on my form based on the value I have selected" and I have made the last name the searchable field.



It works....For completely unique last names. In the case of non-unique last names~Johnson for example~It will only populate the field with the first Johnson in the Table.

So for example I type in johnson in the Combobox and I see a list of 3 different Johnsons lets say fred, ethel and lucy. Assuming Lucy was the first johnson added to the table, if i click on fred or ethel, lucy's data will be shown. Where am I going wrong?

Thank you in advance,

-Matt

[ranman256]

the query for the combo box should be set to DISTINCT, if you are only using last names.
in the query property , set UNIQUE VALUES = TRUE
select distinct [last] from tNames

then when user picks the lastname, filter the continuous form on that.

[sinisterfrog]

I believe (because I am inexperienced) I just did that and did not have success.. It turns out I forgot this was pulling from a query. When I made a quick form based on the table this issue resolved itself. Thank you for your help though.

-Matt