Dear reader,



How can I move the curser from one field to the next field in the record
after an action triggered by the event After click. The form is of the type
Datasheet.

The next code in the event After click: Docmd.GoToControl
"NextFieldName"

shows the error the command or action isn't available now. How can I force
the cursor to the next field in a form of the type DataSheet.



Thanks for any help.

Kind regards,

Simon

Your question isn't very clear, but I assume you're trying to move to the
next field

1) After the current field is filled in

and

2) Without using <Tab> to move to the field in the Tab Order

In order to do this, the data in the first field has to always have the same
number of characters in it; how else would Access know when you were done
entering?

Where "X" is the length of the data in YourTextBox and NameOfNextField is
the next control to gain focus.

Private Sub YourTextBox_Change()
If Len(Me.YourTextBox.Text) = X Then NameOfNextField.SetFocus
End Sub

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200803/1

Cheezy solution: use the SENDKEYS function and send a TAB character.

Richard Rost
www.599CD.com