after add new record …how do I move cursor (Access 97)

Topic

New Reply

after the command:
DoCmd.GoToRecord , , acNewRec
I want to move the cursor or tab to a certain field how would I code that?

Reply | Quote

Replies

Are you working with a form?

Reply | Quote

yes working with a form and I think that when it clears for a new record its starting at the sub form I want it to
start on the main form.

Reply | Quote

This might help

Forms!NameOfYourForm![NameOfControlOnYourForm].SetFocus

Reply | Quote

thanks the set focus works great but I had a requery working after update and now it doesnt?
Combo6.Requery…….this in the box that i set focus too ….Combo6 is next thing tab too after input in
text box….how can i refresh or requery that combo box?

Figured it out that
Me.Refresh
fixed it for me

Reply | Quote

Keep in mind that doing things in code doesn’t always have the same effect as doing them interactively from the user interface. Some of the events don’t necessarily fire when you manipuate the controls through code.

Reply | Quote