Visible radio button based on field

[ECEK]

I can do this if there is one record: ie

Private Sub Form_Open(Cancel As Integer)
If Me.field1 ="DontShow" Then
Me.cmd_splt.Visible = True
Else
Me.cmd_splt.Visible = False
End If
End Sub

This creates a button that masks my radio button ie hides it.
However this only works on single forms.

I need it to be different for each record in a continuous form.

Im putting the code in the "OnOpen" property. Maybe that's my problem?

I've also tried conditional formatting but it wont over-ride a transparent text box.

Thanks for the help in advance.

 

[vbaInet]

Conditional formatting doesn't have a Visible setting and you can't apply conditional formatting to a button or a checkbox.

There might be a workaround. Is the checkbox supposed to be read-only?

 

[ECEK]

My idea was to have a non working command box or text box that sits over my working checkbox and if a certain criteria is met the text box is visible and if not then it isn't visible therefore allowing the checkbox to be ticked.

 

[vbaInet]

Ok I see, it's unfortunately not possible. As an alternative you could add some validation code to uncheck the checkbox if field1's value is "don't show ". This should be run in the After Update event of field1 and the checkbox and also in the Current event of the form (just in case).

 

[ECEK]

Yes thanks. I have another post to try this.

The idea is that when I press the checkbox it produces todays date.
what I want to do is compare todays date with a date on the form.
If the todays date is before the forms date then do not allow the check box to be ticked.

http://www.access-programmers.co.uk/forums/showthread.php?p=1440144#post1440144

 

[vbaInet]

Is there any need of generating today's date via the checkbox when you can already perform the validation using the Date() function?