Recordset not updatable

Hi!

I created a form for users so they can browse contents of database and update fields when needed. However, when I finished creating my update routine. I got an error message on my <recordset>.edit statement saying that the recordset is not updatable.

How can I make it updatable?

Post you SQL statement that is providing the data to your form. The odds are that the SQL statement is not updatable and untill you Simplify the statement you won't be able to update the data using a bound form. You will have to use either DAO or ADO to do it.

S-

SELECT * FROM tblGeneralSection INNER JOIN tblGeneralSection2 ON tblGeneralSection.SiteID=tblGeneralSection2.SiteID WHERE tblGeneralSection.SiteID = " & Val(txtSiteID.Text)

I did not use the Form Wizard. I created an ADO recordset using this SQL statement.

The txtSiteID is a text box I used to accept user input to display the record.

Can you post the code you are using to update the record

S-

Hi!

I was able to fix it. It seems that if you do not define a primary key in the table, it makes the recordset not updatable.