Multiple checkboxes on the form

[Tomeczek]

I'm building the application using Access 2007.
I have four checkboxes on my form. Checking off different checkboxes will control the VBA routines "behind" the button.

I realized, that during the execution of the form, my four checkboxes behave like "radio buttons": only one checkbox can be checked off, checking second box cleares the first one. Am I doing something wrong? Missing something?

Also: how do I read the status of the box? There is no "value" property (as in VB6).

Thank you in advance for your advice!

[maxvernon]

you most likely placed the checkboxes inside a Frame in order to group them together logically. You really want to place them inside a Rectangle, not a frame. The Frame will allow only a single checkbox to be "checked" whereas the Rectangle will allow any, all, or none of the checkboxes to be checked at the same time.

[Tomeczek]

Thanks, maxvernon. That was it!

Now: how can I set initial values on checkboxes and option (radio) buttons using VBA? There is no "value" property...

[mshmyob]

For a CheckBox control just do it like this. Replace 'chkControl' with your checkbox control name

[CODE=vb]
' check for FALSE means NOT CHECKED
If Me.chkControl = False Then
'do something here
Else
'do something else
End If
[/CODE]

Cheers,

Thanks, maxvernon. That was it!

Now: how can I set initial values on checkboxes and option (radio) buttons using VBA? There is no "value" property...

[missinglinq]

Mshmyob's code does set the checkbox's .Value property! Why did you think it didn't have one?

Welcome to TheScripts!

Linq ;0)>

[Tomeczek]

Mshmyob's code does set the checkbox's .Value property! Why did you think it didn't have one?

Welcome to TheScripts!

Linq ;0)>

Great place! So much information here! And help, too.

You're right, it's there, but not shown in the Property Sheet.

Thanks !