Adding all to Cbo list

  • Thread starter Thread starter Junior
  • Start date Start date
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;
 
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..
 
Back
Top