Add "*" or All to Combo box on Form

[hotrod1952 via AccessMonster.com]

I have a form: MAINTSUBLABOR with a combo box the Rowsource Type is:
Table/Query. Rowsource is SELECT DISTINCTROW [MAINTActiveAssetList].[AssetID]
FROM [MAINTActiveAssetList];
(MAINTActiveAssetList is a query)
I am using the combobox results as criteria in another Query [Forms]!
[MAINTSUBLABOR]![Combo11]

As it is now I can return the results for a specific AssetID. What I need is
to be able to have an "All" assets option added so I can also get results for
all of my assets.

I have read several posts on this but I am unable to come up with the
correct syntax or way to accomplish this.

 

[Douglas J. Steele]

See http://www.mvps.org/access/forms/frm0043.htm at "The Access Web".

Note that you'll have to change your criteria in the other query to treat
"All" properly. Where you currently have [Forms]![MAINTSUBLABOR]![Combo11]
as a criteria, you'll need

[Forms]![MAINTSUBLABOR]![Combo11] OR ([Forms]![MAINTSUBLABOR]![Combo11] =
"All")

 

[hotrod1952 via AccessMonster.com]

Thanks for your help!

See http://www.mvps.org/access/forms/frm0043.htm at "The Access Web".

Note that you'll have to change your criteria in the other query to treat
"All" properly. Where you currently have [Forms]![MAINTSUBLABOR]![Combo11]
as a criteria, you'll need

[Forms]![MAINTSUBLABOR]![Combo11] OR ([Forms]![MAINTSUBLABOR]![Combo11] =
"All")

I have a form: MAINTSUBLABOR with a combo box the Rowsource Type is:
Table/Query. Rowsource is SELECT DISTINCTROW

[quoted text clipped - 12 lines]

I have read several posts on this but I am unable to come up with the
correct syntax or way to accomplish this.