Search on Form Problem

[Musa via AccessMonster.com]

Hi,

I have a table CLIENT with a PK of SurveyID. I have a form based on this
table. I would like for the User to Search on the Client's First and Last
Name. However, the First Name text box is separate from the Last Name text
box. I thought about using simple combo boxes for each text field but this
would increase the chances of the User selecting the wrong name (especially
if the name is like "Smith). I have tried various solutions from this web
site but nothing that seems to "fit" in my db.
I even tried concatenating using a query but couldn't get the selection from
the combo box to synch with the Main Form record.

Thanks

 

[NetworkTrade]

a list box or combobox control can display to the user multiple fields to aid
them in selecting the correct record....where multiple names can be the
identical one may sometimes display city, address or telephone as well to aid
in the user making the right selection.....

but once selected it is a unique PK and then the form will show the data for
this record....

 

[Allen Browne]

One approach would be to use a combo that contains both names (and the
hidden primary key), so it jumps to the desired record. See:
Using a Combo Box to Find Records
at:
http://allenbrowne.com/ser-03.html

Another would be to apply a filter to the form, based on whichever search
boxes the user put something in. This requires some coding. For an example,
see:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html

If you cannot do that, you may be able to use Filter By Form.