Focus in first empty control?

  • Thread starter Thread starter CW
  • Start date Start date
C

CW

I have a subform with a continuous form display of costs (invoice details)
which are entered here on this form.
When the form is opened, the cursor is in the very first control on the
first line. Once several invoices have been entered this is irritating
because we need to be down in the first empty control i.e. on a new line, to
start new input.
How can I achieve this?
Many thanks
CW
 
Place the following line of code in the Enter event of the subform control:

DoCmd.GoToRecord , , acNewRec

HTH,

Rob
 
Back
Top