So I have a check box on a form that is attached to a field on a Link Table.
If you do not have a record created yet and click the check box, the whole
thing hangs - there is no primary key set.

So what I want to do is run an if/then function which checks/unchecks the
box if there is information in the main field (which contains a key on the
Link Table record) and does not if said field is empty. However, I can't see
where the checkbox action comes in.

I'm hesitant to use [Control].enabled because this is on a continuous
subform, so turning one instance on/off seems to turn the whole set off.

Grateful for any views on this...

Max

You can use the checkbox.enabled property. You just need to set it in the
OnCurrent Event. That way, it's only looking at the current record.
Something like:

Form_OnCurrent

If isNull(me.field1) Then
me.checkbox1.enabled = false
Else
me.checkbox1.enabled = true
End If

Hope this helps.
--
Amy E. Baggott

"I''''m going crazy and I''''m taking all of you with me!" -- Linda Grayson


"Maxwell" wrote:

> So I have a check box on a form that is attached to a field on a Link Table.
> If you do not have a record created yet and click the check box, the whole
> thing hangs - there is no primary key set.
>
> So what I want to do is run an if/then function which checks/unchecks the
> box if there is information in the main field (which contains a key on the
> Link Table record) and does not if said field is empty. However, I can't see
> where the checkbox action comes in.
>
> I'm hesitant to use [Control].enabled because this is on a continuous
> subform, so turning one instance on/off seems to turn the whole set off.
>
> Grateful for any views on this...
>
> Max
>