Disabling a check box

[Robert C]

I have a check box on a subform called Contacts. If this box is ticked then the name of the contact appears on a particular report.

I would like to have this check box (and its label) enabled only when there is a contact shown - ie when the ContactID field has data in it.

Does anyone have any ideas how I can achieve this.

Thank you.

 

[Axis]

Here's an example for the OnCurrent property of your form:

IIf(IsNull(Me!ContactID),Me!CheckBox.Visible = 0,Me!CheckBox.Visible = -1)

You'll need to substitute the actual names of your fields for those in this example.