Opening a Form at a blank entry

P

Pamela

When I open my form I want it to open and the next available blank entry, I
do not want it to open on the first entry in my table, that is what it is
doing now.

Please let me know what propety to set to do this
Thank You
 
F

Fred Boer

Hi Pamela:

You need to set the form's "Data Entry" property to "Yes".

HTH
Fred Boer
 
R

Rick Brandt

Pamela said:
When I open my form I want it to open and the next available blank entry, I
do not want it to open on the first entry in my table, that is what it is
doing now.

Please let me know what propety to set to do this
Thank You
Click to expand...

Either...

Set the DataEntry property of the form to Yes. That will cause it to filter out
all existing records upon opening and will only show the new blank record
position.

....or...

Use code in the Open event of the form...

DoCmd.RunCommand acCmdRecordsGoToNew

On large table in a networked app the second option is not recommended because
of the amount of data pulled over the wire. For a local app either is fine.
 
Top