Hi,

In a continuous form, how do I make the empty field
(designated for entering a new record)appear as the first
field listed in the list instead of the last? Or is there
a way to direct the tab order so when I open this form my
cursor is already in the new record field?

Thank you!

You cannot make the new record row at the top one.

To go to the new record row:
RunCommand acCmdRecordsGotoNew
The form must have focus for that to work.

Alternatively, if you do not want the old records to show, set the form's
DataEntry property to Yes.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Lizzy98" <(E-Mail Removed)> wrote in message
news:1d49001c4235c$1816b040$(E-Mail Removed)...
>
> In a continuous form, how do I make the empty field
> (designated for entering a new record)appear as the first
> field listed in the list instead of the last? Or is there
> a way to direct the tab order so when I open this form my
> cursor is already in the new record field?
>
> Thank you!