Read only error

[Cindy (Brown) Glidewell]

I designed a form in a job-cost program where I intended to update records of employees assigned to drafting jobs. The employee names are in a combo/ drop down box. When I try to select an employee, a message shows at the bottom that "Form is read-only". The form properties are selected as "no" to allow Deletions or Additions, but "yes" to edits. Just for fun, I changed add & del to yes, but that didn't work either. Is there another property option that could cause the form to be read-only?

[Access Guy]

Hi Cindy

Check that the sql statement or query you are using as the Record Source for the form is not read only. When in the Query builder view the data and try to change something. If you can then the data is editable and that eliminates that.

If it is read only you may have to simplify the sql. A common mistake is doing something like including a total query in the statement.

Let me know if that fixes it.

[Cindy (Brown) Glidewell]

It is the Record Source. I went back to the query to try to edit a record, and the message at the bottom was "This Recordset is not updatable". I don't think I've mentioned in any of my previous messages, but this program is set up as an Access Project. The query is actually a 'view'. I changed the Record Source to a related table and got another error message about being bound to an unknown field. I'll do some more digging to see if I can get it to work. Thanks for your help!