Re: Creating search form to return results in report

Tech-Archive recommends: Speed Up your PC by fixing your registry

See:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html
The sample database in the article shows the search results in the form, but the code is identical to build the WhereCondition for OpenReport.

If you just want to search on one field at a time, see:
Find as you type - Filter forms with each keystroke
at:
http://allenbrowne.com/AppFindAsUType.html
This one consists of a combo where you choose which field to search, and a text box where you type the value to find. To use it on any form, you just copy the combo and text box, and set one property.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Donald" <Donald@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:FAA8463F-2ED7-4734-8BF3-4DFFF82F4E7D@xxxxxxxxxxxxxxxx
I am creating a mail parcel database that contains information such as first
name, last name, apt # and our unique mail parcel code that we put onto
parcels when they come into our office, for our resident parcel mail. I am
at the point in the development of this database where I need to search the
records in the database with those criteria. I would like to create a search
from that has several textboxs where the user can enter either the first/last
name in one textbox, apt. # in another textbox or our mail code in another.
Each textbox will have a search button next to it. Depending on which search
button is pressed (eg. first/last name, apt. # of mail parcel code), I would
like for the search to display the results (each record found) in a report
for viewing. I'm fairly competent with access, but when it comes to VBA
coding, I need a lot of help. Any guidance or assistance would be greatly
apprecitated. Thanks in advanced.

P.S.
I have pretty good programming background (C, C++, Assembly and Basic) so
you don't have to worry about breaking down the commands or syntax too much.

.

Quantcast