Dropdown box default select all

  • Thread starter Thread starter Harmannus
  • Start date Start date
H

Harmannus

Hallo,

How can i use the default text "select all" in a dropdown box? I hove a
dropdown box tied to a show month dropdown. I want the option "select all"
to show the data for all months. How can i put this text here without
effecting the outcome of the query. I mean the below works just fine if
(shows all months) i leave the dropdown blank.

For the query i use

IIf([Forms]![fdlgReportHours]![Combo9].[Value] Is
Null;[tblHours]![PeriodID];[Forms]![fdlgReportHours]![Combo9].[Value])

Thanx for any tips!

Regards,
Harmannus
 
Many of the questions you have been asking over the last month or so,
including this one, could be answered by looking at the great resource at:

http://www.mvps.org/access



--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
 
Hallo,

Big Brother is watching me ;-) I know this great site and get a lot of
answers from there. Maybe my search arguments are not got as i looked there
and did not find answers in the past. Excuses. I will look better.

Regards,
Harmannus


Adrian Jansen said:
Many of the questions you have been asking over the last month or so,
including this one, could be answered by looking at the great resource at:

http://www.mvps.org/access



--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
Harmannus said:
Hallo,

How can i use the default text "select all" in a dropdown box? I hove a
dropdown box tied to a show month dropdown. I want the option "select all"
to show the data for all months. How can i put this text here without
effecting the outcome of the query. I mean the below works just fine if
(shows all months) i leave the dropdown blank.

For the query i use

IIf([Forms]![fdlgReportHours]![Combo9].[Value] Is
Null;[tblHours]![PeriodID];[Forms]![fdlgReportHours]![Combo9].[Value])

Thanx for any tips!

Regards,
Harmannus
Click to expand...
Click to expand...
 
Back
Top