Search Option

[Beany]

Hi,

I have a database that contains details of different sites. The details include site address, connection details, Line details(telepho ne provider etc) and DSL details........ ..........

There are several sites.......... ..

Basically i want to have a search option(possibly in a form) that will allow the user to search for specific details for example. if the user just wanted to see DSL details of every of site and nothing else ......... or just the site details.and so...........how do i do this?

Has anyone got any examples i can look at............. or any ideas would be appreciated.... ........

thanks

[cyberdwarf]

Hi, Beany


Just to get you started...

Try adding a few check boxes to your form:-

• View DSL info
• View Site info
• View line details
• View connection details, etc

At this point you are in a position to build a query based on the selections made by your user, or to open a form with the filter condition based on your user's choices.

HTH

Steve

[Tanis]

Try here for a good example of a search form.

http://support.microsoft.com/kb/209645/