Focus in first empty control?

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
 
R

Rob Parker

Place the following line of code in the Enter event of the subform control:

DoCmd.GoToRecord , , acNewRec

HTH,

Rob
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top