I have a "Yes/No" combo box (set to required) and I want the focus to shift
to differnet controls (on the same form) based on the selection of "Yes" or
"No". Would this have to be placed on the "Exit" event?

I tried Google...and no luck.
I'm sure there's gonna be an "If" statement involved.

TIA,
-Orv
Access2003

Hello.

You have a couple of choices of where to put this. I would probably put
it in the AfterUpdate event, because this should set the focus to the
next control as soon as a value is selected from the list. Putting it in
the OnExit event would work, but the focus wouldn't shift to the
specified control until the user exits the combo box.

It would probably look something like this:

Private Sub Combo0_AfterUpdate()

If Combo0.Value = "Yes" then
Control1.SetFocus
Else
Control2.SetFocus
End If

End Sub





Orv wrote:

Hello.

You have a couple of choices of where to put this. I would probably put
it in the AfterUpdate event, because this should set the focus to the
next control as soon as a value is selected from the list. Putting it in
the OnExit event would work, but the focus wouldn't shift to the
specified control until the user exits the combo box.

It would probably look something like this:

Private Sub Combo0_AfterUpdate()

If Combo0.Value = "Yes" then
Control1.SetFocus
Else
Control2.SetFocus
End If

End Sub





Orv wrote:

Hello.

You have a couple of choices of where to put this. I would probably put
it in the AfterUpdate event, because this should set the focus to the
next control as soon as a value is selected from the list. Putting it in
the OnExit event would work, but the focus wouldn't shift to the
specified control until the user exits the combo box.

It would probably look something like this:

Private Sub Combo0_AfterUpdate()

If Combo0.Value = "Yes" then
Control1.SetFocus
Else
Control2.SetFocus
End If

End Sub





Orv wrote:

Hello.

You have a couple of choices of where to put this. I would probably put
it in the AfterUpdate event, because this should set the focus to the
next control as soon as a value is selected from the list. Putting it in
the OnExit event would work, but the focus wouldn't shift to the
specified control until the user exits the combo box.

It would probably look something like this:

Private Sub Combo0_AfterUpdate()

If Combo0.Value = "Yes" then
Control1.SetFocus
Else
Control2.SetFocus
End If

End Sub





Orv wrote:

Thanks for the quick help.
I can't get either of the examples to work.
They both go to the next control.

I tried a simple testDB with only the 3 controls (flat DB and it still went
to the next control) instead of the "Yes/No" being pulled from seperate tbl.
I know I'm making this harder than it is.



"fredg" <fgutkind (AT) example (DOT) invalid> wrote

Thanks for the quick help.
I can't get either of the examples to work.
They both go to the next control.

I tried a simple testDB with only the 3 controls (flat DB and it still went
to the next control) instead of the "Yes/No" being pulled from seperate tbl.
I know I'm making this harder than it is.



"fredg" <fgutkind (AT) example (DOT) invalid> wrote

Thanks for the quick help.
I can't get either of the examples to work.
They both go to the next control.

I tried a simple testDB with only the 3 controls (flat DB and it still went
to the next control) instead of the "Yes/No" being pulled from seperate tbl.
I know I'm making this harder than it is.



"fredg" <fgutkind (AT) example (DOT) invalid> wrote

Thanks for the quick help.
I can't get either of the examples to work.
They both go to the next control.

I tried a simple testDB with only the 3 controls (flat DB and it still went
to the next control) instead of the "Yes/No" being pulled from seperate tbl.
I know I'm making this harder than it is.



"fredg" <fgutkind (AT) example (DOT) invalid> wrote