Form entry replacing table record instead of adding new record

[aolough]

Hi,

I've a simple form connected to one table. The problem is that the new data entered via the form is replacing an existing record in the table, instead of just adding a new record. What am I missing?

Recordset Type: Dynaset


Data Entry, Allow Additions, Allow Deletion, Allow Edits all set to Yes

Thanks

[Rod]

Are you overtyping the existing data?

[pfunk]

you need to add a button that adds a new record. In design view of your form, under the controls section you will see a button option. Selct that and add it on to your form. The Command Button Wizard will appear. Here you will select Record Operations under Categories and then Add New Record under actions. Give it a picture or text (New Record). Name this button if you want and select finish. Then got back to form view and select the button add new information and do it again. (You may want to add a save record button as well). Close the form and select the table to ensure your new data was added! Hope that helps.

[uncletreetrunk]

you can also use a little SQL to add the record to the table

Dim strSQL as String

strSQL = INSERT INTO [tblname] ([fieldname1] , [fieldname2],...) VALUES ( " & Me.number & ", ' "& Me.string &" ', #"& Me.date &"#)

Debug.Print strSQL
CurrentDb.Execute(strSQL)

http://www.baldyweb.com/ImmediateWindow.htm
http://www.baldyweb.com/BuildSQL.htm

[aolough]

Thanks Rod, I was! Sorry I thought I replied to this sooner. Thanks for the other replies too.