Combo Box - Supplied by query but need wild card too.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a combo box that has a data source of a select distinct query. I have
a button that when clicked opens a report based on the value selected in the
combo box (this is no problem). My question is, I would like to also have at
the top of the selection, an * to select all records. I have put in the
default of the combo box an *, but when I click on the command button to open
report, it is blank. When I select any other value from combo box and click
button, I get the report I am expecting. How can I get it to select all
records. The report and combo box are fed from the same table. I want to be
able to see a single client's report, or all of the clients on the report.
Thanks in advance
 
Thanks Karl,
That helped. One other issue related to this. Since I put the * in the
Default property of the combo box, it comes up then first time you come to
the combo box. Once you select something from the list, the * is no longer
available. Is there a way to keep it as part of the list after the first
selection?


KARL DEWEY said:
In your query criteria try this --
Like [Forms]![YourForm]![YourComboBox]

Kenny A. said:
I have a combo box that has a data source of a select distinct query. I have
a button that when clicked opens a report based on the value selected in the
combo box (this is no problem). My question is, I would like to also have at
the top of the selection, an * to select all records. I have put in the
default of the combo box an *, but when I click on the command button to open
report, it is blank. When I select any other value from combo box and click
button, I get the report I am expecting. How can I get it to select all
records. The report and combo box are fed from the same table. I want to be
able to see a single client's report, or all of the clients on the report.
Thanks in advance
Click to expand...
Click to expand...
 
You will need to add it to your record source. Just add a phony record with
an asterisk.

Kenny A. said:
Thanks Karl,
That helped. One other issue related to this. Since I put the * in the
Default property of the combo box, it comes up then first time you come to
the combo box. Once you select something from the list, the * is no longer
available. Is there a way to keep it as part of the list after the first
selection?


KARL DEWEY said:
In your query criteria try this --
Like [Forms]![YourForm]![YourComboBox]

Kenny A. said:
I have a combo box that has a data source of a select distinct query. I have
a button that when clicked opens a report based on the value selected in the
combo box (this is no problem). My question is, I would like to also have at
the top of the selection, an * to select all records. I have put in the
default of the combo box an *, but when I click on the command button to open
report, it is blank. When I select any other value from combo box and click
button, I get the report I am expecting. How can I get it to select all
records. The report and combo box are fed from the same table. I want to be
able to see a single client's report, or all of the clients on the report.
Thanks in advance
Click to expand...
Click to expand...
Click to expand...
 
Karl,
Not the most orthodox way to get it to work, but it did do the job.
Thanks for your knowledgeable help.

KARL DEWEY said:
You will need to add it to your record source. Just add a phony record with
an asterisk.

Kenny A. said:
Thanks Karl,
That helped. One other issue related to this. Since I put the * in the
Default property of the combo box, it comes up then first time you come to
the combo box. Once you select something from the list, the * is no longer
available. Is there a way to keep it as part of the list after the first
selection?


KARL DEWEY said:
In your query criteria try this --
Like [Forms]![YourForm]![YourComboBox]

:

I have a combo box that has a data source of a select distinct query. I have
a button that when clicked opens a report based on the value selected in the
combo box (this is no problem). My question is, I would like to also have at
the top of the selection, an * to select all records. I have put in the
default of the combo box an *, but when I click on the command button to open
report, it is blank. When I select any other value from combo box and click
button, I get the report I am expecting. How can I get it to select all
records. The report and combo box are fed from the same table. I want to be
able to see a single client's report, or all of the clients on the report.
Thanks in advance
Click to expand...
Click to expand...
Click to expand...
 
Back
Top