Manage a Option Group control from a combo

M

maella

Is it possible choose the pages of an option group control from a combo?

If so how could I get it?

Thanks
 
W

Wayne-I-M

Hi Maella

What are "pages of an option group". Can yoiu explain it in another way
 
M

maella

ok sorry, I took the literal translation from the Spanish. Manage the Tab
Control
 
M

maella

Sorry, I made an estrange translation from the Spanish I would to say a Tab
control
 
W

Wayne-I-M

Use DoCmd.GoToControl "Form name on tab control" on the AfterUpdate event
of the combo

Like this

Say you have a main form with 3 tabs .
On each tab is a form (form1 is on tab 1 - form 2 is on tab 2 and form 3 is
on tab 3)

On you main form create a combo (source = value list Form1;Form2;Form3) and
put this after update

Private Sub ComboName_AfterUpdate()
If Me.ComboName = "form1" Then
DoCmd.GoToControl "Form 1"
End If
If Me.ComboName = "form2" Then
DoCmd.GoToControl "Form 2"
End If
If Me.ComboName = "form3" Then
DoCmd.GoToControl "Form 3"
End If
End Sub


This said I think it would be much simpler to just click the tab ??
 
M

maella

Thanks a lot, and sorry again

Wayne-I-M said:
Use DoCmd.GoToControl "Form name on tab control" on the AfterUpdate event
of the combo

Like this

Say you have a main form with 3 tabs .
On each tab is a form (form1 is on tab 1 - form 2 is on tab 2 and form 3 is
on tab 3)

On you main form create a combo (source = value list Form1;Form2;Form3) and
put this after update

Private Sub ComboName_AfterUpdate()
If Me.ComboName = "form1" Then
DoCmd.GoToControl "Form 1"
End If
If Me.ComboName = "form2" Then
DoCmd.GoToControl "Form 2"
End If
If Me.ComboName = "form3" Then
DoCmd.GoToControl "Form 3"
End If
End Sub


This said I think it would be much simpler to just click the tab ??
Click to expand...
 
W

Wayne-I-M

Don't worry about speaking english well here - I am not english (I live here
now) and many people are here from all over the world. If you ask the basics
then an expert like a mvp may answer - if not then you may just get a normal
human (mvp is short for super-human) to try and help if possible.
 
M

maella

quote "This said I think it would be much simpler to just click the tab ??"

I've made a tag for each item (i.e.). All the tabs have the same buttons and
the same format. I've removed the upper tag of each tag, too. When you select
an item from the combo, all the controls change seeming there is only a form.
Besides this way I avoid people change of tab before ending the task in this
item.
Very useful! ;-)
 
Top