toggle button value 1

[davyre]

hi,
i'm creating a form that has two toggle button, to select between two different textbox that user can insert into.
These two toggle buttons function as switch between two textbox, i.e when user select Togglebutton 1 then textbox1.visible=true and textbox2.visible=false vice versa.
Now the problem is how can I add a button to submit/continue that understands which togglebutton that user choose?

If Me.Toggle5 = True Then
    MsgBox ("yes")
End If

If Me.Toggle6 = True Then
    MsgBox ("no")
End If

the code above shows error runtime 2427 : You entered an expression that has no value
any help? Thanks!

 

[dhookom]

Are these buttons in a group? If so, the Option Group has a value rather than the individual buttons.

Duane
Hook'D on Access
MS Access MVP

 

[randy700]

Perhaps, something like...

If Textbox1.visible Then
    [i]do something[/i]
Else
    [i]do something else[/i]
End If

Randy

 

[davyre]

@dhookom:yes it is in a group as I made it using Option Group. But I cannot see the group name on the property sheet selection
@randy: Thanks! It worked! I was trying to use the same idea but not sure what to say in the IF clause. Thanks!

 

[dhookom]

Every control on your form has a name. An option group has a value that is changed when you select different options/toggles.

Duane
Hook'D on Access
MS Access MVP

 

[davyre]

thanks for your additional info, dhookom. Great!