Using Find on More than One Field at a time

[Gretchen]

I have 3 fields, FirstName, MI, LastName. Is it possible to do a find for i.e. Rose Smith and not just Rose or Smith - and then than to scroll through 35 Rose's or 60 Smith's to find Rose Smith specifically?

Thanks so very much for your help !!

 

[charityg]

Are you using Access's find form, or a custom find form? This is very doable if you build your own custom form to find records.

 

[Gretchen]

We've simply been using the Access Find Form. But since this is becoming a hassle, would like to do a custom one it seems. However, have no clue how to do that! Can you explain please?

 

[charityg]

I've attached a sample db with a Search form that will search all fields specified in the underlying query for a listbox.

Start by opening the Customers form. Click the find button to open the frmSearch. Type the search criteria in the textbox. The listbox will filter based on what is typed. Double click the entry in the listbox to move to that specific record on the Customer form.

Let me know if you need any help implementing this.

 

[Gretchen]

Charity, thank you for your response and zip file. But I definately need your help in implementing this. I don't have any idea what to do with it now that I have unzipped it!

Also, sorry it took so long to get back here. I've been so overwhelmed at work I've barely had time to breathe!!