View Full Version : need help creating a search form


daclown81
01-02-2002, 12:24 PM
I don't really know much VB code. I need to find a way to create a form that will search my tables and give only specific info.

For example: Service Records Table

I need to know how to search for Service records from a specific Company between 2 dates and receive only the info from that company between those 2 dates in a Report.

Anyone know some cod for this or where I could find some info on doing this?

Thanks,
Mike

David R
01-02-2002, 02:00 PM
There's a couple ways to do what you want, I think. The simplest is probably with parameters, unless you know the dates in question won't be changing.
Create a query from your table (or regular query, if there are other filters/calculations going on) with the Company field Criteria set to [Enter as much of the company name as you know:]. Then in the date field you want to search by, set the Criteria to Between [Enter starting date:] And [Enter ending date:]

Basing your form off of this copy should give the result you want, though I haven't tested it.

HTH,
David R