how do I assign a variable to a check box or radio control?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tlscorpadmin - 22 Feb 2008 02:29 GMT

I need to assign the value of a radio control or check box when clicked on to
a variable, preferably using the SetTemVar macro.

Reply to this Message

Allen Browne - 22 Feb 2008 02:39 GMT

Use the AfterUpdate of the control (if it's a stand-alone control), or of
the option group (if it's part of an option group) to SetValue (in a macro)
or assign the value (in code.)

Not sure if it's really a good idea though. Considerations such as:
- You can quite easily read the value from the form.
- Doesn't work in versions of Access before 2007.
- If it's a bound form, the tempvar would not be up to date when you move to
a different record.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I need to assign the value of a radio control or check box when clicked on
>to
> a variable, preferably using the SetTemVar macro.

Reply to this Message