if a ComboBox is null in a Form, must not allow a checkbox to be t

[Guest]

I have a check box named: [Report] in a subform named:[lbl_ScrapDB_subform]
also I have a Form with a ComboBox named: [shift_combo]

what I want is this:

if [shift_combo] is null
then [Report] must not allow to be true,


how do that?

Thanks in advance.

 

[Guest]

Well it depends on when you want some kind of action to take place. Do you
have a button where to click on or should it be in the after update of the
combo or what...

Anyway I think you can use something like:

me.report=not isnull(me.shiftcombo)

This means that the report check will only be true if the shift combo is
anything else then null.

hth