My form is overwriting my table entries!

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

Guest

I have used the autoform button to create a form which populates records into
one of my database tables.

Upon my importing of records successfully, my form attempts to overwrite the
first entry within the table, as opposed to adding a new entry.

Why would this be happening?
 
Mike said:
I have used the autoform button to create a form which populates
records into one of my database tables.

Upon my importing of records successfully, my form attempts to
overwrite the first entry within the table, as opposed to adding a
new entry.

Why would this be happening?
Click to expand...

By default a form opens to the first record of the underlying record source.
If you want to use it only for new entries then set its Data Entry property
to true.
 
This fixed it. Thank you Rick!

Rick Brandt said:
By default a form opens to the first record of the underlying record source.
If you want to use it only for new entries then set its Data Entry property
to true.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using form and subform not connecting to two separate tables 0
Separate Form 0
Data Entry Form 3
Prevent Duplicate Form Entries 0
Access Automatically Send a notification email once a record is added 0
Pop up form - field not updated 2
Update table when entry is saved 10
Data entry for a table from a form 2

Back
Top