Executing SQL From An Option Group

[DAPOOLE]

How can I pass an Option Group parameter to execute a stored procedure? Basically I have 3 stored procedures and want the user to define which one of the three to execute by what option then select. I am looking for sample coding along the lines of:

if option 1 then
strSql = "exec pump "
if option 2 then
strSql = "exec dump "
if option 3 then
strSql = "exec marry "

Thanks.

 

[ajetrumpet]

an option group comes by default with default values, such as 1, 2, 3. on the event to execute, call the procedure:

if me.optiongroupname = 1 then
   call proc1
elseif me.optiongrouopname = 2 then
   call proc2
else
   call proc3
end if

if the controls are NOT in a group, you'll have to check for TRUE/FALSE for each one as they are not assigned a value.