Access data entry form sequence

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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??
 
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.
 
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.
 
Excellent, Bruce. I'm new to Access and looked around for the answer for a
while. This is the only one that worked. Great!!
 
Back
Top