Runtime error 2110

[JSD]

Hello,

I am getting a runtime error when I try to move the focus away and back to a control after an error msg occurs. The error occurs on a 'jobno' field. I am trying

Me!insu.SetFocus
Me!jobno.SetFocus

And I get a runtime error that says it can't move the focus back to jobno. Any ideas why?

I appreciate the help

Jeremy

 

[AvGuy]

It depends on the error that's occuring in the JobNo field. Have you entered a JobNo that's not in the table? Have you entered one form of variable when Access is expecting another (text instead of number for example)? Whatever the reason you're going to have to determine and clear the source of the original error before moving focus back to the JobNo field.
AvGuy

 

[TonyJollans]

Hi Jeremy,

In what Event are you trying to do this, and what is the error?

Enjoy,
Tony

------------------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading FAQ222-2244 before you ask a question.