DoCmd.GoToControl problem

[CCSC0208]

Hello,

I am new in VBA. I took some codes from one database, but something doesn't work.

In a Form view, on VarB field, on Exit, a function will check a condition. After entering the value of VarB and clicking Enter key, if the condition is false, I want the cursor stays in VarB field. The following code works in the database where I took the codes, but it doesn't work in my database. Could somebody help me check this? Thank you for your time.


If Condition = 6 Then
VarA = VarB
Else
MsgBox "Please do again!"
DoCmd.GoToControl VarB
End If

 

[ZOR]

Have you tried VarB.setfocus instead of the gotocontrol?

 

[CCSC0208]

I tried "VarB.SetFocus" instead of "DoCmd.GoToControl VarB". It works in the database where I took the code from, but it still doesn't work in my database. Is there any difference between Access97 and 2002 at this point? Any restriction? This field is visible and enabled.