Access data entry form sequence

T

TBuser

I have a data entry form that I use to enter tracking information. I am
trying to get the form to open on a blank record without displaying all of
the previously entered records. The form should open on record 1 and only
show the records I enter at any given time. I currently have another form
that does this and cannot reverse engineer how it was accomplished.

Any suggestions??
 
R

Rick Brandt

TBuser said:
I have a data entry form that I use to enter tracking information. I
am trying to get the form to open on a blank record without
displaying all of the previously entered records. The form should
open on record 1 and only show the records I enter at any given time.
I currently have another form that does this and cannot reverse
engineer how it was accomplished.

Any suggestions??
Click to expand...

Set the DataEntry property of the Form to Yes.
 
B

BruceM

Open the form in design view. Click View > Properties to display the form's
peoperty sheet. Click the Event tab, click On Open, click the three dots,
click Code Builder, OK. Add the following code at the cursor:
Me.Recordset.AddNew

Also on the property sheet, click Format and change the Default View to
Single Form.
 
P

Peach

Excellent, Bruce. I'm new to Access and looked around for the answer for a
while. This is the only one that worked. Great!!
 
Top