Skip a Field

[Nylex]

I am using Access 2003

When making entries there is a coded number beside each entry a number from
1 to 15)
When I enter a field I am looking up its code - if it is <4 then this field
must be skipped and go to the next field
I have used an "Event Procedur" on "Entry" and have tried using
DoCmd.GoToControl "WithdrawalAmount"
I have also used
Forms!Transactions!WithdrawalAmount.SetFocus
None of these work

Help would be appreciated

 

[Al Campagna]

Nylex,
It would be helpful if you had named the controls involved, the types
of controls, and shown the code you used.
Try this... use your own control names...

Private Sub Code_Enter()
If Code < 4 Then
DoCmd.GoToControl "WithdrawalAmount"
End If
End Sub
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."