Need help with validation rules of CheckBox

[educate889]

Need some guidance!

I have a bound checkbox (Pass) on mainform (01_Audit_Entry) that allows user to check if the parts passed 1st inspection.

However, I want to either disable/hide/or validate this checkbox by comparing it to the subform (01_Sub_AuditDetails) when they enter a reason of failure and qty.

I hope this makes sense . . .if not please let me know and I will try to clarify.

If you think I am going about this wrong , please provide other stratagies to do this better.

Thanks in advance!

 

[chrissie1]

it makes sense, but im not sure about one thing. you want to validate the checkbox if someone enters something in a subform?

then in the afterupdate of the textbox (or whatever control you have) in the subform put this

forms![formname].form![checkboxname] = true

where formname is the name of the form where you have the checkbox Christiaan Baes
Belgium
"What a wonderfull world" - Louis armstrong

 

[educate889]

Okay, I actually want to make the checkbox false if they give a reason for a failure, so I will modify your code to false!

One more thing, does a check box give a true false value or a 0, -1. And when you are putting in code which to you refer to.

thanks again!

 

[ssecca]

A check box actually holds a 0, -1.

When coding you can use either method TRUE, FALSE or 0,-1.

Most people use TRUE,FALSE because it is easier to read when debugging.