Control Focus

[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

 

[Gary Miller]

Attila,

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

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________

 

[JohnWL]

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