How to use toggle/option buttons on a form in Acc2003

[Killer42]

Hi all.

I'm coming from a VB6 background so this is just confusing me a little. I have a form where the user can select one of a number of years to search. The selection doesn't relate directly to any particular table or field in the database, but will be used in code later to build queries.

I have tried putting a bunch of radio/option buttons in a frame, and also tried putting a bunch of toggle buttons on the form, and run into the same problem either way. How do I tell when one of them is selected, so I can change some defaults displayed on the form?

In VB6, of course, it would be a very simple matter to code behind the Click event. But the nearest events I can find for these controls are the KeyUp/Down and MouseUp/Down, which are really not what I want. For one thing, they still fire even if, for example, you press the mouse then move off the button, and so don’t select it.

Any help is appreciated.

[MMcCarthy]

Drag an option group onto the form from the toolbar.

Use the wizard to set up the basic group. It will allow you to assign an integer value to each option. It will default to 1, 2, 3, etc.

Put your code in the On Click event of the Frame rather than the buttons.

Then code using select case statement

 
Private Sub Frame1_Click()
    Select Case Frame1
 
    Case 1
        ' do something
    Case 2
        ' do something
    Case 3
        ' do something
    Else
        ' do something
    End Select
 
End Sub
 
 

[NeoPa]

Radio buttons come within a frame.
The AfterUpdate event will trigger every time the operator changes the selection.

[Killer42]

Radio buttons come within a frame.
The AfterUpdate event will trigger every time the operator changes the selection.

Thanks to both of you. In this case I think the frame's OnClick event is the better fit for what I'm doing.

[NeoPa]

So, beaten by a quicker AND more appropriate post... MMcCarthy does it again - Grrrr.
Seriously, it's cool you've got a good answer.

[Killer42]

So, beaten by a quicker AND more appropriate post... MMcCarthy does it again - Grrrr.
Seriously, it's cool you've got a good answer.

Need to brush up on those speed-typing skills. :)