• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 626
  • Last Modified:

MS Access How to update a radio button status with field name?

I have a radio button that controls a field - press the button, field changes to "cancelled".

When I re-open this form, the field says cancelled, but the radio button isn't turned on.

How can I auto turn on the radio button if the field is already set to cancelled?
0
DJPr0
Asked:
DJPr0
  • 2
2 Solutions
 
nickinthoozCommented:
If field.text = "cancelled" then
option.value= 1

In an option group, you check the value of the Option group control (MS
autonames this Frame if you don't assign a name). This will get the value
associated with checked item in the option group. If you want to force the
item to be checked you set the Option Group's value to one of the check box
control's option value.

If Me.YourFrame.Value = 1 Then
        MsgBox "Option 1 is selected"
    ElseIf Me.YourFrame.Value = 2 Then
        MsgBox "Option 2 is selected"
    End If

Open in new window


maybe that'll help.
0
 
DJPr0Author Commented:
Where do I input this code? Form - Load?
0
 
nickinthoozCommented:
I would guess, if you want the form to check it on load then yes.
0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now