Parameter Query - Select All

[ndeeley]

Hi there,

I`m running a query from the values in a combo box:
[forms]![frmMyForm]![cboMyValues]

..against a field that has two values - in this case Workshops. So the user can select reports to run on Exewater or Tolgus workshops.

However, my client has requested the combo box has a third selection - Both Workshops, so the query selects all records from the fields.

How do I put this into my Combo box, so that a value of `Both` inserts a value into my query that selects all the records?

Thanks

[Rabbit]

Make a second hidden column and bind the combo box to that column where the value of Both is *.

In the criteria, use Like Forms![Form Name]![Combobox Name]

[ndeeley]

Rabbit,

Thanks - but make a second hidden column where? In my primary table (the one with the field name of `Workshops`, or in another table where the users can select the values in the combobox?

Sorry for being so thick!

[ndeeley]

Rabbit,

No need to reply - I`ve got it to work.

You are a genius. Thanks for your help.

Neil

[Rabbit]

Not a problem, good luck.

[dceglar]

Make a second hidden column and bind the combo box to that column where the value of Both is *.

In the criteria, use Like Forms![Form Name]![Combobox Name]

I am trying to do the exact same thing - but I am having the user use a drop-down list on a form based on a lookup table. Once the user makes a selection and clicks on OK, the form goes invisible. Then on a report the "Upon Open" is fetching the combo box results [combo2] from the form. But, basically I believe it is the same situation. Right now, the report only runs based on the one selection (of several possible ones) and I would like the option for the user to pull the report based on all the selections listed in the lookup table. Where exactly do you create the second hidden column? And where do you put the criteria? I have tried different things to no avail. Thanks!

[dceglar]

Hi there,

I`m running a query from the values in a combo box:
[forms]![frmMyForm]![cboMyValues]

..against a field that has two values - in this case Workshops. So the user can select reports to run on Exewater or Tolgus workshops.

However, my client has requested the combo box has a third selection - Both Workshops, so the query selects all records from the fields.

How do I put this into my Combo box, so that a value of `Both` inserts a value into my query that selects all the records?

Thanks

I am trying to do the exact same thing - but I am having the user use a drop-down list on a form based on a lookup table. Once the user makes a selection and clicks on OK, the form goes invisible. Then on a report the "Upon Open" is fetching the combo box results [combo2] from the form. But, basically I believe it is the same situation. Right now, the report only runs based on the one selection (of several possible ones) and I would like the option for the user to pull the report based on all the selections listed in the lookup table. Where exactly do you create the second hidden column? And where do you put the criteria? I have tried different things to no avail. Thanks

[Rabbit]

I am trying to do the exact same thing - but I am having the user use a drop-down list on a form based on a lookup table. Once the user makes a selection and clicks on OK, the form goes invisible. Then on a report the "Upon Open" is fetching the combo box results [combo2] from the form. But, basically I believe it is the same situation. Right now, the report only runs based on the one selection (of several possible ones) and I would like the option for the user to pull the report based on all the selections listed in the lookup table. Where exactly do you create the second hidden column? And where do you put the criteria? I have tried different things to no avail. Thanks

You put the other column in the table that's supplying the recordsource for the combobox. You include that column in the combobox but hide it. The second column stores the name of the form to open.