search function

[haytatreides]

I am trying to build a search function into a form where the user inputs a string, and then a query is built to find a record where the chosen field has that string in it. I would like to open a form based on that criteria that opens the records one at a time. So i need to know how to filter the records i return. I have the sql using the like clause, but some will return more results than others, and those results must be displayed one at a time, but i have no idea how to do it.

hayt

 

[KenReay]

Hi

Just base you form on the recordset returned by the query, and have navigation buttons to move thru the records

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[jbento]

I found a good example of how to do a search database. You can download here:

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

I hope this helps,

Jerome Benton
JERPAT Web Designs

http://www.jerpat.org

GOD Is Good All The Time!!!