Recordset can't be updated?

[tcshred]

This is driving me crazy.

I am creating a database for call quality monitoring. Just when I thought everything was working perfectly, I get an error saying the record set can't be updated. I can't find anything useful about it online either.

here is my database:
I have a table which is essentially an template for call quality. each record has a primary key ID number. I also have a table for staff and their teams which is linked to the other table.

I have a form where you can select the staff member, and there is a tab control where the second tab has their quality results via a sub form. I have made the primary key a hyperlink so when clicked it brings up the quality form of the original record. however it can't be updated and gives me the message saying record set can't be updated.

I want the user to be able to click the hyperlink, bring up the record and edit where required.

Is this even possible?

any help would be really appreciated.

 

[pbaldy]

I wouldn't use hyperlink for that, I'd just have numeric keys. One simple way to do what you're asking for is:

http://www.baldyweb.com/wherecondition.htm

 

[tcshred]

That is essentially what I did, but as part of an on click macro. So, click the numeric primary key, and the on click macro executes the docmd.openform and uses the primary key as the Where Condition. This all works and the correct form is opened to the correct record. It just can't be updated.

The purpose of setting it up this was is so it gives the user an easy way to update records.

 

[pbaldy]

I'm not sure if using that data type for a primary key will make it read-only when linked. Is that form being opened based on a query that's read-only?

 

[tcshred]

It is based on a query. How do I tell if the query is read only?

 

[pbaldy]

Try and edit/add a record in the query.

http://allenbrowne.com/ser-61.html