Can't Control Focus

[Frank Wagner]

Where the focus goes must involve something I'm not aware
of.

I have a text control, where On_Exit I have the statement

Me.SameControl.SetFocus

Even though it executes this statement, the focus goes to
an option control that I don't want it to go to.

If I put in a statement for it to go to some other
control that I can use to send it back to the original
control, I get the error message #2110 - "Microsoft
Access can't move the focus to that control"

I'm totally confused. Any help would be appreciated

Thanks

Frank Wagner

 

[Rick Brandt]

Where the focus goes must involve something I'm not aware
of.

I have a text control, where On_Exit I have the statement

Me.SameControl.SetFocus

Even though it executes this statement, the focus goes to
an option control that I don't want it to go to.

If I put in a statement for it to go to some other
control that I can use to send it back to the original
control, I get the error message #2110 - "Microsoft
Access can't move the focus to that control"

I'm totally confused. Any help would be appreciated

There are certain events where setting focus is not allowed. If you simply set
the Cancel argument in the Exit event to True the control will never lose focus
and it will be unnecessary to set it back.

 

[Guest]

Rick:

I couldn't read that last part of your message, but I was
not aware of the cancel option and that helps. Also I
have since found the Tab Order screen. Between the two
items, I think I'm set.

Thanks

Frank Wagner