Can't get new record to open - newbie problem

  • Thread starter Thread starter dab1147
  • Start date Start date
D

dab1147

Thanks in advance for the assist.
I created a database that I've used for over 1000 entries. When I set it
up, I set it up to open the 1st record when I entered the database. I now
wish to have the database open with a new record. Access Help says to set
NewRecord property to True. I can't find this property in Form Design view
or Form View. What must I do to make this Access 2000 database open a form
with a new record?


(e-mail address removed)
 
Either set the data-entry property to Yes, or add this in the Open even of
the form:
DoCmd.GoToRecord , , acNewRec
 
Thanks Kevin, but as a newbie I am unable to find the data-entry property.
I've looked at the properties of the open form in Form view and Form Design
view - No luck. Would this have anything to do with the fact that this
database is replicated? Sorry if this comes across as being elementary, but
I am a neophyte. Thanks for your assist.
 
The data-entry property is on the data tab of the Form Properties when in
design view.

I have no idea if replication affects this, since you should NEVER replicate
forms, queries, etc. Ideally in a replication scenario, you have split the
database into Front-end and back-end, and are replicating the Back-end only.
Replicating the front-end is just asking for corruption. It is easier to
deploy a new FE as changes are made.

Hope that helps...
 
Back
Top