Access 2002 Run-Time error 2110

[okesedad]

When I shift from form view to data sheet view, I get the following:
run-time error '2110': Microsoft access cannot move the focus to the control
option1.
The window that appears with the error message has a 'END' and 'DEBUG' tab.
when I choose 'debug' it goes to some coding, but doesn't appear to be doing
anything, yet when I exit I get a message 'this will stop the debugging' (or
words to that affect). Anyone else experiencing this, and how to keep it from
happening?

 

[Wayne Morgan]

I would suspect that the code is trying to move the focus to a control that
doesn't show in data sheet view, such as a button. What does the line of
code that debug has highlighted say? What procedure is the code in?

 

[okesedad]

Mr. Morgan
The debug highlights the following line of code in yellow:
"Me![Optional].SetFocus"
As I kept 'playing' with it, I suspect this error is caused by my using the
EXIT ("X" in the top right corner of the window) to close the data sheet
view. I thought I could close the data sheet view using the "X" and then go
back to the form design view. I suspect I closed the entire file and that is
why I got the 2110 error. Anyway, I think I am okay now. thank you very much
for your assistance and for taking the time to answer. Sincerely, Lou Briant