Check box status not changing

[Razor1]

I have check box that should hide a field or display a field depending on its status. I placed in the after update procedure. If it starts out as false and changes to true then it displays the fields but once changed to True it always shows True.

Here is the code.

If Me!ContractChairs.Visible = True Then
Me!Product.Visible = True
ElseIf Me!ContractChairs.Visible = False Then
Me!Product.Visible = False
End If

Razor1

 

[Andrzejek]

Did you try just a one line like:

Me!Product.Visible = Me!ContractChairs.Visible

Have fun.

---- Andy

 

[Knicks]

Have you tried either repainting or refreshing the form after the procedure is run?

 

[dhookom]

Can you tell us:
"after update procedure" update of what?
Which is your check box?
Do you understand you might need to add this code to the On Current event?

Duane
Hook'D on Access
MS Access MVP