parameter query

L

leo

Hi All,
I have a parameter query i have attached to a form and all works well, even
did some vb code to make it work!!.

Now i'd like to extend the query to ask a second question.
In the original query i have created a drop down list the user selects and
as such i'd like to add a second drop down list to further break down the
query.

the original query looks like this:

[forms]![Not resolved by Builder]![builders]
i'd like to add another expression like below
[forms]![issue type]![issues]

i envisage the form will have 2 drop down lists and then the ok button.

any ideas or more info required?
 
O

Ofer Cohen

If both Combo's are located on the same form, you need to have the same path.

Forms![FormName]![ControlName]

So, If that the original [forms]![Not resolved by Builder]![builders]
Then this [forms]![issue type]![issues] need to be [forms]![Not resolved by
Builder]![issues]

Just add this path in the criteria section of the field in the query
 
A

Allen Browne

If you want to create a search form that offers several drop-down boxes, and
the user doesn't have to enter something in all of them, see:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html

There is a sample database to download and see the code that sets the Filter
of the form to so shows the right results.
 
L

leo

Thanks guy's, works a treat. also helps if you use the correct names!!

Ofer Cohen said:
If both Combo's are located on the same form, you need to have the same path.

Forms![FormName]![ControlName]

So, If that the original [forms]![Not resolved by Builder]![builders]
Then this [forms]![issue type]![issues] need to be [forms]![Not resolved by
Builder]![issues]

Just add this path in the criteria section of the field in the query
--
Good Luck
BS"D


leo said:
Hi All,
I have a parameter query i have attached to a form and all works well, even
did some vb code to make it work!!.

Now i'd like to extend the query to ask a second question.
In the original query i have created a drop down list the user selects and
as such i'd like to add a second drop down list to further break down the
query.

the original query looks like this:

[forms]![Not resolved by Builder]![builders]
i'd like to add another expression like below
[forms]![issue type]![issues]

i envisage the form will have 2 drop down lists and then the ok button.

any ideas or more info required?
Click to expand...
Click to expand...
 
L

leo

Hi Allen,
thaks for that, it's a very different approach than i originally thought but
i'll give it a try as i think it might be easier for the end user.
thanks
Leo

Allen Browne said:
If you want to create a search form that offers several drop-down boxes, and
the user doesn't have to enter something in all of them, see:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html

There is a sample database to download and see the code that sets the Filter
of the form to so shows the right results.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

leo said:
Hi All,
I have a parameter query i have attached to a form and all works well,
even
did some vb code to make it work!!.

Now i'd like to extend the query to ask a second question.
In the original query i have created a drop down list the user selects and
as such i'd like to add a second drop down list to further break down the
query.

the original query looks like this:

[forms]![Not resolved by Builder]![builders]
i'd like to add another expression like below
[forms]![issue type]![issues]

i envisage the form will have 2 drop down lists and then the ok button.

any ideas or more info required?
Click to expand...
Click to expand...
 
Top