Using Form to Search

[sedixon]

Hello,

My project is to re-write a database that stores bibliographic information about articles for the office in Access 2000. When someone wants to print out a reference list they would need to utilize this tool, but they don't necessarily need to print out every reference that is found - especially when they use a wild card to search.

So I would like to develop a form that I can use to search through my database. I think I have found the code to do this or something similar in this forum (Thank you!). But my main problem is figuring out how to be able to select only certain results from the query and output them to the report.

Any suggestions on how to do this?
Thanks!
Sarah Dixon

 

[rushdib]

Create a small form which has a search criteria and in criteria tab of the query which produces the report, enter Like Forms![formname]![fieldname]. In this way you can enter wild card characters (*) to search records.