Append Problem 1

[tyang01]

I have a problem I'm using a form to append to the records of data in my table. It keeps overwriting the current data in my table. I've got a RecordId field that is autonumbered and set to not have copies. So my problem is when I open up the form. It selects all the bound fields from the current data and updates them with the new data that has been input. Instead of making a new record. I'm not sure how to go about it. If anyone has some suggestions it would be very much appreciated.

Thanks!

 

[lars7]

Have you set the property to Data Entry = yes

 

[RickBerem]

Hello,

You should make sure that when you enter your form it opens up in a NEW record. Using something like :

DoCmd.GoToRecord acActiveDataObject, Me.Name, acNewRec

should do the trick.

SG

 

[tyang01]

I'm not sure where to find it. I looked in table properties and the query but I don't see anything like that.

 

[tyang01]

It works. Thank You!