Adding all to Cbo list

J

Junior

Using the following in a cbo rowsource
the cbo is used as a parameter for a query.

Want to add a row to the cbo for user to select 'All' and all services would
be included in the parameter.
[SVC] and [Service] are text fields
Thanks

cbo rowsource:
SELECT [QcboServiceList].[SVC], [QcboServiceList].[Service] FROM
QcboServiceList;
 
J

Junior

Need to add more info - this is actually on ef several cbos that provide
parameters for a report. i saw the answer to use a function to open the
report with or without a filter- howver i also have a date filter that needs
to remain..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

another try - (all) to cbo list - help plse 4
textbox info based on cbo 2
cbo box Catch 22 situation 12
combo box and what it shows 1
Cancel On Lost Focus Event 3
Cbo Not In List code error 9
Auto populate cbo based on other cbo if that cbo value exists in t 0
fill cbo from input into txtbox 1

Top