Recordset is not updateable

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

Guest

I have a form that does auto-complete without code. But I am getting an
error that says Recordset is not updateable. Do you have a solution to fix
this problem. The form is filled out but from the combo box you cannot
select from it and you cannot type on that section of the form.

Thanks,
K
 
I have a form that does auto-complete without code. But I am getting an
error that says Recordset is not updateable. Do you have a solution to fix
this problem. The form is filled out but from the combo box you cannot
select from it and you cannot type on that section of the form.

Thanks,
K
Click to expand...

The Form's Recordsource property is presumably the name of a Query;
you are getting this message because that query is not updateable. Try
opening the Form in design view; view its Properties; on the Data tab
click the ... icon by the Recordsource property to open the query in
design view. If you look at it in datasheet view, do you see a *> "new
record" line at the bottom? Can you change data in the datasheet?

If not, check the following issues:

- Is it a Totals query (is the Greek Sigma icon selected, and is there
a Totals line in the grid)? If so, it is not and cannot be made
updateable.
- If it's a multitable query, do you have a unique Index such as a
Primary Key on the "one" side table joining field?
- Or, is it a query with four or more tables? Such queries are rarely
updateable.

If you can't figure out why it's not updateable, open the query in SQL
view and post it here.

John W. Vinson[MVP]
 
I still can't figure out why it's not updateable. Here is my query in SQL
View id you can help me I really appreciate it.

SELECT tblCustomers.SiteNum, tblCustomers.[Site/NameID],
tblCustomers.[Site/Name], tblName.Address,
tblName.[Building/Suite],tblName.City, tblName.State, tblName.Zip
FROM tblName INNER JOIN tblCustomers ON tblName.[Site/NameID] =
tblCustomers.[Site/NameID]
ORDER BY tblCustomers.[Site/Name];

Thanks,

K
 
I still can't figure out why it's not updateable. Here is my query in SQL
View id you can help me I really appreciate it.

SELECT tblCustomers.SiteNum, tblCustomers.[Site/NameID],
tblCustomers.[Site/Name], tblName.Address,
tblName.[Building/Suite],tblName.City, tblName.State, tblName.Zip
FROM tblName INNER JOIN tblCustomers ON tblName.[Site/NameID] =
tblCustomers.[Site/NameID]
ORDER BY tblCustomers.[Site/Name];
Click to expand...
Is [Site/NameID] the Primary key of tblCustomers? Or does it otherwise
have a uniuqe Index?


John W. Vinson[MVP]
 
The SiteNum is my primary key. Is that how it should be. Do you know why I
having the Recordset is not updateable error. If you can help I would really
appreciate it.

Thanks,

K

John Vinson said:
I still can't figure out why it's not updateable. Here is my query in SQL
View id you can help me I really appreciate it.

SELECT tblCustomers.SiteNum, tblCustomers.[Site/NameID],
tblCustomers.[Site/Name], tblName.Address,
tblName.[Building/Suite],tblName.City, tblName.State, tblName.Zip
FROM tblName INNER JOIN tblCustomers ON tblName.[Site/NameID] =
tblCustomers.[Site/NameID]
ORDER BY tblCustomers.[Site/Name];
Click to expand...
Is [Site/NameID] the Primary key of tblCustomers? Or does it otherwise
have a uniuqe Index?


John W. Vinson[MVP]
Click to expand...
 
The SiteNum is my primary key. Is that how it should be. Do you know why I
having the Recordset is not updateable error. If you can help I would really
appreciate it.
Click to expand...

If SiteNum is the primary key, you should be joining on that field
rather than on the Site/NameID! Or am I missing something?

Try

SELECT tblCustomers.SiteNum, tblCustomers.[Site/NameID],
tblCustomers.[Site/Name], tblName.Address,
tblName.[Building/Suite],tblName.City, tblName.State, tblName.Zip
FROM tblName INNER JOIN tblCustomers ON tblName.[SiteNum] =
tblCustomers.[SiteNum]
ORDER BY tblCustomers.[Site/Name];

Or if tblName does not have a SiteNum field, you will need a unique
Index on Site/NameID. In any case, it's the field in the INNER JOIN
clause which must have a unique Index (such as a primary key) in the
"one" side table, and a nonunique Index (automatically generated when
you define the relationship) in the many side table.

John W. Vinson[MVP]
 
Back
Top