Control Focus

  • Thread starter Thread starter Attila
  • Start date Start date
A

Attila

When a form is open, is there a way to have it open on the
next avaliable EMPTY record instead of opening on the very
first record all the time.

Thank you,
Attila
 
Attila,

In the Data section of the Form properties, set it to
DataEntry = Yes.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
 
I notice no one gave you a really good solution, so I'll respond a bit late
here. Setting the form property DataEntry to Yes prevents you from editing
or deleting records, it only allows adding of records.

To have a form open to a new ("empty") record, place the following line in
the form's Load event:
DoCmd.GoToRecord , , acNewRec
This will cause the form to load with the New Record selected, which is what
you seem to have asked for.

John Loewen
 
Back
Top