Searching a database 2

[billmsacces]

I would like to search records in a form (frmCitation) by name (txtName) and/or date (txtPubdate). I made a simple form (frmSearch) with input boxes and a search button (cmdSearch). I have tried using the Find method, which would simply match terms in the input boxes, but I am not familiar enough with VB to get it to work.
Is there a simple solution or should I give up for today?
Thanks.
B

 

[Rolliee]

Never give up. There are scads of search code bits around here. Look in the FAQ first. Then try something and post back. We like to see what your present code is. Tells us a lot.

rollie@bwsys.net

 

[jbento]

Download this search database. It is great. I use it and have modified a copy of 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!!!