Don't display field if checkbox is false

[mick3911]

I have a subform that is designed from a query which contains various fields which are locked and not enabled (i.e. read only).
One field is a date field (Due Refresher) which has conditional formatting where if the date is less than today the text turns red and another field which is a checkbox (Required).
What I am trying to do is that when the subform is opened if the checkbox (Required) is False’ then the Due Refresher field is not displayed.
I have tried the following on the On Open and On Load (separately) but nothing is happening.

If Me.Required = False Then
Me.DueRefresher.Visible = False
Else
Me.DueRefresher.Visible = True


End If

Can anyone help me out please?

[Welshgasman]

Walk through the code after setting a breakpoint and see what the values are.

I would have thought you would want this on the current event if you change a record.?

You could simplify it to

Me.DueRefresher.Visible = Me.Required

as well.

HTH

[mick3911]

Hi Welshgasman,

Many thanks for your reply.

The record is changed using another form which is changed only by people who have access to it.

The form I am wanting to only display the Due Refresher date can be seen by anybody but they cannot edit it.

[mick3911]

Am I putting the code in the right place?

[Micron]

You don't make a form for every permission - you make one form and do things to it accordingly, like lock or hide controls, or make the whole form read-only or whatever. Perhaps I misunderstood but that's what I got out of the above.

Aside from that, is the checkbox bound? If not, it probably has no value unless someone actually has clicked it at least once. The checkbox is on a subform? If not then which form has your code? A subform loads first, then a main form. You can't check anything about a main form in subform open or load events.

[Missinglinq]

Assuming that, like most Subforms, you're talking about a Datasheet Form...using the OnLoad or OnOpen event will format all Records going by the Value of Required in the first Record displayed when the Form opens...not each Record appropriately.

And there is no direct way of using Conditional Formatting to make a Control invisible...you can only Disable it.

Linq ;0)>