MS Access - searching in a form

[alpinhasov]

Let's say I have created a form. It has the following fields:

1. Last name
2. First name
3. date of birth.
4. A search button.
5. Radio buttons which let a user to choose the search criteria.(i.e by last name, first name or date of birth).

How do I implement the search feature in Access.

Also let's say I have 10 students in a class. I would like to search by class number - lets say the number is 100. Once I wrote in a textbox 100 a window will pop up with the list of the students. Once I choose a student his information appears in appropriate textboxes like his first name, last name, school id etc...

I would appreciate any help.
Thank You.

[Freon22]

I set up a access 2000 database for the company that I work for. That was a few years ago. I know that in my form I set the search button up with the control F key. Tomorrow I will look it up for you, its done with macros. I know that everything you have ask for can be done with access. I just don't know if I can help you enough to get it all done.

[Freon22]

Ok its a new day. I looked up the database that I had setup. I have a Search button, delete record button, and a few other on it. Each one was a pain for me to get working. Between posting on forum like this one and reading books on MS access, I was just able to get it to work. So I'm not going to be of any help. The best thing I can say is to buy a good book on access and take it one step at a time. Also if you already have data in your database make sure you make a backup copy before you start.

[alpinhasov]

Ok. Thank you.