search form 1

[lushh]

hi guys. i need help on doing a search on a database. i am using ms access 2003 and the form looks like this:

http://i114.photobucket.com/albums/n258/lushh_16/searchbyclientform.jpg

when the user will type in for example "EOT Corp." in the "Search for" field and will choose "Company Name" in the "Search by" combo box, the database will look for all the "EOT Corp." entries under the field of "Company Name" in a table. does anyone have a sample VBA code for this function? thank you very much. all your replies would mean so much.

 

[PHV]

Have a look at the Filter and FilterOn properties of the Form object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[lushh]

thanks a lot.. i will try to look on that.