Checkbox in form = TRUE when other Checkboxes on form = TRUE

[Summit_IT]

I have a form that has a number of checkboxes to indicate the status of a part (Record). I want the "PartNeeded" checkbox to change from (Default)False to True when [FailedVisual] = True Or [FailedNDI] = True Or [PartMissing] = True.

Compiling the following code doesn't show any errors, but it doesn't work. Right now, it's under Form_Load.

If [FailedVisual] = True Or [FailedNDI] = True Or [PartMissing] = True Or [Retired] = True Then [PartNeeded].Value = True

I bet there is a simpler way of doing this.



Thanks in advance!

[Welshgasman]

So what happens when you move to another record?
Try the Current Event.

I would just use PartNeeded = True

[moke123]

Assuming that you want the value to change when you check off one of those options you would need to call that code from each checkbox.
I'd create a separate procedure and then call it on current of the form,as well as on afterupdate of each checkbox.

I'd also suggest using the Me. keyword as in Me.PartMissing, etc.

[Micron]

That procedure would have to be a function and not a sub if I'm thinking along the same lines. However, I don't see what's wrong with that code line, but "doesn't work" doesn't help much. If all of the controls are bound, what would you need the current event for? That's a missing puzzle piece? As for that code being simpler
If [FailedVisual] Or [FailedNDI] Or [PartMissing] Or [Retired] Then [PartNeeded] = True

[Summit_IT]

Putting the code under Current Event was the winner. It works the way I want it to.

Thanks

[Welshgasman]

Putting the code under Current Event was the winner. It works the way I want it to.

Thanks

My thoughts were as you went from record to record?, but if you amend any of those criteria controls, then then PartNeeded is not going to change to reflect that, unless you move off that record and then back to it?