DoCmd.OpenTable

[Daniel]

I would like to open a table and have the user add a new
entry using the DoCmd.OpenTable "tLang", ,acEdit.
However, I want the cursor to be in the first field of a
new record. Is that possible? Just to make it easier for
the user.

Thanks

Dan

 

[Ken Snell]

Do not open the table for the user to enter data! Use a form that is bound
to the table and open the form. You then can control the cursor location,
the validity of what is being entered, etc.

Never ever allow a user to enter/edit/see data directly in a table.

 

[losmac]

DoCmd.OpenTable "AAA"
DoCmd.GoToRecord acDataTable, "AAA", acNewRec