Adding a Search Function to database

[yabloni]

Hi,

I am working on creating an electronic client database. It is a very simple design: for every client, a single form is completed with their information.

However, what I am looking to do is to add a function that allows me to search for specific records based on some criteria (e.g. last name, client id...).

For example, a new form called 'SearchForm' would have a field which I could type the criteria in and then with a click of a button it pulls up that client's information form. What I would like is some help with the VBA code for this, I am fairly new to VBA but willing to learn.

Your help is appreciated.

 

[jackd]

See free video tutorial here
http://www.datapigtechnologies.com/flashfiles/searchform.html

 

[yabloni]

Thank you very much that video definitely got me started on the right path.

My ultimate goal was to have a form open up displaying the client record that the user searched for.

However, I've managed to deal with that by adding another button that allows the user to open a specific client record by inputting the unique ID (the unique id is found by using the search from the video).

Thanks again!!!

 

[alansidman]

This will eliminate the search lookup and take you directly to the record:

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

Alan

 

[yabloni]

Thanks for the additional info Alan, that's extremely useful!