Search Box Code?

[courtney]

Hi,

I'm creating a database in Access 2007 to track the volunteers at the local animal shelter I work at. Currently, we have over 100 volunteers, so it is much needed.

I would like to make a form to look up volunteers by either their last or first name. I've google'd everything and the codes are overwhelming! I am hoping somebody can help me?

I have no problem sharing the database I've already created, if needed.

Thank you!
Courtney

 

[boblarson]

Why not just create a combo box to select the name from? In fact, if you have a bound form which you want to go to their record, you can have the wizard even code it for you. You go into design view on the form and select the combo box to add and the wizard should give you three options and the third is to find a record based on selection. Follow through the wizard and you have it. If you want to, you can have two combos (by following the same steps) but instead of last name for the one you can select first name as what you want to look for. The key is that it looks for the record ID associated with that user (which is what I hope you are using in your table to identify a volunteer).

 

[courtney]

I've tried this, but maybe I messed it up. I made the combo box through the wizard, but then when I typed in a name it only did by the first letter and it didn't go to the record.

IE. Smith and Seabring -- I would type "S" and get "Seabring" but when I typed "M" it went to last names starting with "M"


I made the combo box in a separate form -- does it need to be in the same form as the volunteer records to go to the record?

 

[courtney]

OH WAIT! I did "list box" I just tried it again with combo box. Thank you!!

 

[alansidman]

Here is another possible solution that may work for you.

http://www.datapigtechnologies.com/flashfiles/buildcustomfilter.html

Alan