open a blank form in Access 2002

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

Guest

I am trying to get the default form that opens up to be blank and not the
first record so that a user can either enter data or find records that may be
in the table already.
 
In the Load event procedure of the form:

If Not Me.NewRecord Then
RunCommand acCmdRecordsGotoNew
End If
 
Easiest way is to set the "Data Entry" property of the form to "Yes". It will
default to new record.
 
John,
Nsumis requested "so that a user can either enter data or find records".

Using Data Entry mode does not allow Browsing, Deleting, or Editing or
existing records... only new record data entry.

hth
Al Camp
 
AlCamp said:
John,
Nsumis requested "so that a user can either enter data or find records".

Using Data Entry mode does not allow Browsing, Deleting, or Editing or
existing records... only new record data entry.

Not quite true. All one has to do to browse existing records in a form that was
opened in Data Entry mode is go to the menu or toolbar and "remove all filters".
If the user will mostly be doing data entry it would be more efficient to open
in data entry mode and then remove all filters (better yet apply different ones)
when the user wanted to look at other records.

Having the form open to "all" records is never a good idea.
 
Rick,
I agree with your response, but... given the original question, I felt
Nsumis was realtively new to Access, so I kept my response direct and to the
point.
While Data Entry is a legitimate solution, I would imagine it would
generate another post from Nsumis asking... "Data Entry works great, but how
can I see my other records?"
Thanks for the heads up on that though...
Al Camp
 
Back
Top