Very simple MS Access problem - please help

m4rshmul3 · 26 Apr 2009 at 14:42

Hi,

I have a MS Access form with a number of check boxes. I want the following scenario.

When checkbox 1 is selected I want Checkboxes 2 and 3 to be greyed out so they cant be selected.
Any help appreciated!

Thanks

m4rshmul3 · 26 Apr 2009 at 14:47

I currently have the following -

Private Sub Box1()
If Me.Box1 = True Then
Me.Box2 = False

End If

End Sub

Which will remove the tick from the box, but I want the box disabled so it cant be selected.

Pho · 26 Apr 2009 at 14:56

Box2.enabled = false

Dolph · 26 Apr 2009 at 15:27

What Pho said, or use radio button groups as they were designed to enable a user to select from multiple exclusive options.

http://msdn.microsoft.com/en-us/library/aa511488.aspx