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