Help with Radio buttons in Access 2003 [Solved]

[ade0282]

I am looking to create a set of radio buttons.

Radio 1 selects search form
Radio 2 select print form
Radio 3 selects reports

on click of the ok button it then selects the form and opens it

if anyone could advise me of the code i would be most grateful

[Ecniv]

Create a frame
Create the option buttons in the frame, ensure that each one has a different value in the Data tab of the properties.
The easiest open form command is something like:

select case framename
case 1
DoCmd.Openform "frmname1"
case 2
DoCmd.Openform "frmname2"
case 3
DoCmd.Openform "frmname3"
end select

Which you put in the onclick code for the button.

Best to rename the controls into something more developer freindly... :)

Also use the intellisense for the docmd.openform, incase there are other things you need on it