Dropdown box default select all

[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

 

[Adrian Jansen]

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]

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

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,

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