Search Function

[Simon.Argent]

I am aware of how to create a basic query where I can type details into
a field and pull back the results. What I would liketo do is have a
form where I fill out fields from a drop down list (lookup table?) and
then be able to have the reults based on this.

Basically, rather than having to remember each category, I want to
select the information I am querying.

Hope you understand what I am trying to do and can help.

Thanks in advance,
Simon

[Keith Wilby]

<Si**********@gmail.com> wrote in message
news:11**********************@g43g2000cwa.googlegr oups.com...

I am aware of how to create a basic query where I can type details into
a field and pull back the results. What I would liketo do is have a
form where I fill out fields from a drop down list (lookup table?) and
then be able to have the reults based on this.

Basically, rather than having to remember each category, I want to
select the information I am querying.

Hope you understand what I am trying to do and can help.

Thanks in advance,
Simon

Yes you can do this by setting a combo box's source property to "Field
list". A little code to build up your filter string and Bob's your uncle.
I can send you an example if you like ... but have you considered using the
built-in "filter by form" method? Infinitely more flexible IMO.

Keith.
www.keithwilby.com

[PieOPah]

I know about the "filter by form" method, but using this you either
have to be on a record with a parameter you want so you can sort by
that entry or, you need to previously know the field you want to filter
on.

If I can manually create the filters to be selected from a drop down
list then this will avoid the complications of spelling mistakes.

If you could send me some code that may aid me that would be greatly
appreciated.

[Keith Wilby]

"PieOPah" <Si**********@gmail.com> wrote in message
news:11**********************@g43g2000cwa.googlegr oups.com...

I know about the "filter by form" method, but using this you either
have to be on a record with a parameter you want so you can sort by
that entry or, you need to previously know the field you want to filter
on.

If I can manually create the filters to be selected from a drop down
list then this will avoid the complications of spelling mistakes.

If you could send me some code that may aid me that would be greatly
appreciated.

Duly sent.

Regards,
Keith.