searching for a record in a form

[billmsacces]

I am currently using the built in FIND feature in Access to find records in my database. The FIND feature works but it is clunky. Is there a code that would search specific fields in the database. I’m thinking of something like Query By Form, but instead of displaying the info in a datasheet, it would display it in my form.

The Form I'm using is based on a query called qryCite. (The query is based on tblName and tblPub). The form contains several fields, but the ones I'm interested in searching are txtPubDate, which is the publication date, and txtSurname, which is the last name of the individual. There is also txtFirstName, but it isn't crucial that that one is searchable.

Thanks.
B.

 

[PHV]

Have you tried to play with the Filter property and the DoCmd.ApplyFilter method ?

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

 

[jbento]

Download this database. It is great and I made a copy and modified it to meet my needs.

http://www.jerpat.org/SearchDb.mdb

Jerome Benton
JERPAT Web Designs

http://www.jerpat.org

GOD Is Good All The Time!!!