Using And/Or with Check Box

  • Thread starter Thread starter joebeagle via AccessMonster.com
  • Start date Start date
J

joebeagle via AccessMonster.com

I have a form (form1) with a subform (subform2) and another subform (subform3)
. On subform2 there is a text box for mom's employer's name. On subform3
there is a text box for dad's employer's name. On form1 there is a check box
(Check0) that needs to be filled in automatically when either mom or dad has
an employer, or left blank (false) if neither one has an employer.

I have tried several different solutions including:

Nz(Subform1.Form![Employer], Nz(Subform2.Form![Emplyer], False))

IIf (Not IsNull(Forms![Form1]![Subform1].Form![Employer]) And Not IsNull
(Forms![Form1]![Subform2].Form![Employer]), True, False)

Reversing the above IIf for IIf(Is Null).

Any of them seem to work correctly with one operator (EG mom's info), but
when adding the second operator , dad's info (EG And...), the check box
either stays True all the time, or False all the time.

Any ideas? Can this even be done?

Thanks in advance,

Carol Washburn
 
Assuming that you're using an expression as the checkbox's Control Source:

=(Len([Subform1]![Employer] & "")>0 Or Len([Subform2]![Employer] & "")>0)

Be sure that you're using the correct names for the subform controls (the
controls that actually hold the subform source objects) in the above
expression.
 
Thank you! That worked fine!
Carol
Assuming that you're using an expression as the checkbox's Control Source:

=(Len([Subform1]![Employer] & "")>0 Or Len([Subform2]![Employer] & "")>0)

Be sure that you're using the correct names for the subform controls (the
controls that actually hold the subform source objects) in the above
expression.
I have a form (form1) with a subform (subform2) and another subform
(subform3)
Click to expand...
[quoted text clipped - 23 lines]
Carol Washburn
Click to expand...
Click to expand...
 
Back
Top