Multiple check boxes

[Marc]

I have a list of multiple check boxes on a form, how do I make to where only
one check box can be checked?

 

[Pieter Wijnen]

change to option group

Pieter

 

[J_Goddard via AccessMonster.com]

Hi -

I suggest that you use a radio button option group. This allows only one
option to be selected at a time.

John

 

[Marc]

I successfully got the option groups working, Thank you. Now when I click on
a individual button I need a message box to appear. I noticed in the
properties it didn't have the onclick event. How do I connect a macro to the
button to display a messagebox when it's clicked when the event onlclick is
not available?

 

[J_Goddard via AccessMonster.com]

The easiest way is to use the After Update event of the option group itself.
Clicking any of the buttons in the option group will trigger that event, and
you can check which button was clicked by checking the "value" of the option
group: If me![yourOptionGroup] = somevalue then.....

I myself use VB code to display messages, rather than macros. This might be
the best option on your case, especially if the message to be displayed is
different for each button.

John

I successfully got the option groups working, Thank you. Now when I click on
a individual button I need a message box to appear. I noticed in the
properties it didn't have the onclick event. How do I connect a macro to the
button to display a messagebox when it's clicked when the event onlclick is
not available?

Hi -

[quoted text clipped - 5 lines]

 

[Marc]

ok say my option groups name is MaintenanceTables and the first radio button
is called Clauses and has the value of 1. When you click that button I want
the message to state "Please get the compliance Manager's Approval". May I
have a sample of how the code would be written?

The easiest way is to use the After Update event of the option group itself.
Clicking any of the buttons in the option group will trigger that event, and
you can check which button was clicked by checking the "value" of the option
group: If me![yourOptionGroup] = somevalue then.....

I myself use VB code to display messages, rather than macros. This might be
the best option on your case, especially if the message to be displayed is
different for each button.

John

I successfully got the option groups working, Thank you. Now when I click on
a individual button I need a message box to appear. I noticed in the
properties it didn't have the onclick event. How do I connect a macro to the
button to display a messagebox when it's clicked when the event onlclick is
not available?

Hi -

[quoted text clipped - 5 lines]

I have a list of multiple check boxes on a form, how do I make to where only
one check box can be checked?

 

[J_Goddard via AccessMonster.com]

In the After Update event of the Option group you could have something like
this:

Select case me![maintenancetables]
case 1
msgbox "Please get the compliance Manager's Approval
case 2
msgbox ....
'etc for other values
end select

or, you can use if - then - elseif - endif :

If me![maintenancetables] = 1 then
msgbox "Please get the compliance Manager's Approval
elseif me![maintenancetables] = 2 then
msgbox ....
elseif....

endif

They're both the same, really - whichever you use is a matter of personal
preference.

John

ok say my option groups name is MaintenanceTables and the first radio button
is called Clauses and has the value of 1. When you click that button I want
the message to state "Please get the compliance Manager's Approval". May I
have a sample of how the code would be written?

The easiest way is to use the After Update event of the option group itself.
Clicking any of the buttons in the option group will trigger that event, and

[quoted text clipped - 18 lines]