|
| |
|
Add All to the Top of a Combo Box |
| |
|
To add All to the top of a Combo Box, you can do the following:
Add the following line in the Row Source Property of the Combo Box:
|
select "*","(All)" as expr1 from dummytable union select FieldID,
FieldName from Table order by expr1 |
In the underlying query, add the following criteria under FieldID:
Like
IIf(IsNull([Forms]![formname]![comboboxname]),"*",
[Forms]![formname]![comboboxname]) |
|
|