Need to create a search criteria form on access 2003

[LC2007]

Hello,
Can someone please help me on how to create Search Criteria form, i can't find exactly what i am looking for!!!
i need a search button! but i can't find anything that can help me!

[MGrowneyARSI]

Do you need to lookup records is that what you mean please explain more

[LC2007]

Do you need to lookup records is that what you mean please explain more

Im not sure exactly
Rather then using 'query' on accces, i would like to create a form wth a list of options they can search by to make it easier for the user,

For example searching by

*Company Name
*City
*Post Code
*Dates from and to etc

Then to create a search button that looks at all the criterias in the text/combo boxes and lists them by it's company name and ID in a list box (or anything else) so the user is able to select the records retrieved and by clicking on the 'company name' open it up and it will open in a form veiw rather then a table...

I hope this make sense, thank you!

[kcddoorman]

just subscribing, I have a similar goal in data access pages.

[Jim Doherty]

Hello,
Can someone please help me on how to create Search Criteria form, i can't find exactly what i am looking for!!!
i need a search button! but i can't find anything that can help me!

If you PM me with your email address I will send you a demo db I have recently done in VBA for the benefit of newbies which has a number of useful techniques for searching as you prescribe like building the search SQL on the fly visible to you on screen as it does it, adding records where it doesnt exist, opening a form to a selected record and so on.outputting to excel records returned for manipulation outside of access amongst others.

You might want to disect and rip apart as a helper in your learning curve

Regards

Jim

[LC2007]

If you PM me with your email address I will send you a demo db I have recently done in VBA for the benefit of newbies which has a number of useful techniques for searching as you prescribe like building the search SQL on the fly visible to you on screen as it does it, adding records where it doesnt exist, opening a form to a selected record and so on.outputting to excel records returned for manipulation outside of access amongst others.

You might want to disect and rip apart as a helper in your learning curve

Regards

Jim

[e-mail]

Thanks!