Form with Search, and Print Report functions

[jean2002]

Hello,

I know that Google can be man's best friend in such a situation, but was wondering if anyone can help me more here.

I am looking for some ideas on how to build a form which searches for values as given by a user. E.g. this form has maybe 10 text boxes for search criteria, which can be connected with "AND" and "OR". The results are then given in a list box.
(B.T.W. I have seen something that sorta matches this description on the Access web under "Forms"

It would also be great if some kind of functionality was built in, that allowed the user to print a report based on the search results, by the click of one button.

Any ideas would be very appreciated.

Kind Regards,

JP

 

[PHV]

Take a look here:

http://download.microsoft.com/download/access2000/Sample/1.0/WIN98Me/EN-US/Qbf2k.exe

QBF stands for Query By Form.

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

 

[hymn]

This seems to be one of the best examples for searching at the thread below
Thread702-563930

Hope this helps
Hymn

 

[jean2002]

Thanks for those links...I will keep pursueing my goals with these!