Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Option Group 1

Status
Not open for further replies.

sabavno

Programmer
Jul 25, 2002
381
CA
Hi

I have an option group consisting of two option buttons

The question is how to automaticaly open another form once the option button is clicked (selected)
 
if all you want to do is open a form

Private Sub Frame0_AfterUpdate()
DoCmd.OpenForm "formname"
End Sub
if you want a choice based on the button. this assume you've assgned 1 and to to bottons option values
Private Sub Frame0_AfterUpdate()
select case frame0
case 1
DoCmd.OpenForm "form1name"
case2
DoCmd.OpenForm "form2name"
end select
end sub
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top