Search Form

[James]

Hello Is there any way of making a search form?

I would like it to be something allong the following
lines...

Combo Box at the top with certain values which then pulls
up a form relating to the value selected in the combo box.

Then on each form looking the same there are a range of
check boxes which when ticked they enable either a text
box or a combo box... When values are selected within
these comboboxes or text boxes it uses all the information
to be displayed. in the results part of the form which is
a continuous form catagory.

Is there any easy way of doing this as I have about 11
tables and when I try to link them they just seem to
replicate the data about 20 or so times over and over
again.

Do I actually have to link the tables or is this not worth
the hassle?

Many Thanks

James

 

[Guest]

Very hard within Access
Lots of indepth coding

 

[Gina Whipp]

There is one available on www.mvps.org/access It's probably not what you are
looking for but it will give you an idea of difficult it is to create one.

 

[Adrian Jansen]

I have done this, but unless you are comfortable with a fair bit of VBA code
and SQL handling, its not all that simple to implement. Start with the
code at www.mvps.org/access. If you can follow how that works, I can show
you how to extend it.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control