Combo Boxes Visible/Invisible

[Rick West]

On my form (F_Main) are 10 combo boxes - (Cust01, Cust02, Cust03....Cust10) I only want them visible if the underlying query is not null.



Reason, different projects will have different combo boxes pertain to them and I only want the users to "see" the ones with data behind them.

[maximus]

use DCount to verify whether the record count is null.

[Rick West]

You'll have to help me through this a little more specifically please. I tried adding the DCount function to the Conditional Format of the combo box but could not figure out how to word it.

I used this: DCount("PriSeg", "Q_Cust05Attribute", "PriSeg is null") and turned the box background red if the condition was true. It does not work.

Should I put some code somewhere else other than in the Conditional Format of the combo boxes?