AddNew

[starswirl]

I am trying to add information from the textboxes on my form to the database on the system and it is giving me the error message

Run-time error '3426': This action was cancelled by an associated object.

This is the statement I am using:

Data1.Recordset.AddNew
Data1.Recordset.Fields("ApDate&quot = Text1.Text
Data1.Recordset.Fields("Time&quot = Text2.Text
Data1.Recordset.Fields("LastName&quot = Text3.Text
Data1.Recordset.Fields("FirstName&quot = Text4.Text
Data1.Recordset.Fields("DOB&quot = Text5.Text
Data1.Recordset.Fields("PhoneNumber&quot = Text6.Text
Data1.Recordset.Fields("OtherNumber&quot = Text7.Text
Data1.Recordset.Fields("Transportation&quot = Text8.Text
Data1.Recordset.Fields("Notes and Comments&quot = Text9.Text
Data1.Recordset.Update
Data1.Recordset.Close

I am trying to find out why I am getting this message.

 

[JohnAcc]

Have you made sure that the names of your textboxes are text1, text2 etc?

Rgds

John