Form seemed Read-Only

[emerlita]

I cannot do anything with the form i created. I cannot add, delete, or
modify a record. Is there something i missed here?

 

[John W. Vinson]

I cannot do anything with the form i created. I cannot add, delete, or
modify a record. Is there something i missed here?

Evidently. Of course we can't see the form, so it's hard to guess what.

The most common cause, though, is basing the form on a non-updateable Query.
What's the Recordsource of the form? If it's a query, try opening the query in
datasheet view: is there a blank new record at the bottom? can you edit data
in the datasheet?

If not, see the online help for "updateable" and/or post the SQL view of the
query here.

Other possibilities are that the Allow Edits and/or Allow Additions properties
of the form are set to No.

John W. Vinson [MVP]

 

[emerlita]

Evidently. Of course we can't see the form, so it's hard to guess what.

The most common cause, though, is basing the form on a non-updateable Query.
What's the Recordsource of the form? If it's a query, try opening the query in
datasheet view: is there a blank new record at the bottom? can you edit data
in the datasheet?

If not, see the online help for "updateable" and/or post the SQL view of the
query here.

Other possibilities are that the Allow Edits and/or Allow Additions properties
of the form are set to No.

John W. Vinson [MVP]

i want to paste a screenshot here so that i can show what im talking
about but i can't. is there any way to do this?

 

[Douglas J. Steele]

i want to paste a screenshot here so that i can show what im talking
about but i can't. is there any way to do this?

Binary attachments are strongly discouraged, but it shouldn't be necessary.

John asked what the recordset of the form was. Is it a query or a table? I'm
guessing it's a query, and that the query itself isn't updatable.

 

[John W. Vinson]

i want to paste a screenshot here so that i can show what im talking
about but i can't. is there any way to do this?

No. Binary attachments are NOT welcome in this text-only newsgroup!

Please describe the problem that you are having in words. I understand that
the Form is giving you an error that the form is not updateable. As I said,
this usually means that the Form is based on a Query that is itself not
updateable (or, sometimes, it's just that the Form's Allow Updates property is
set to No).

Open the Form in design view; look at its Properties (click the little square
at the upper left intersection of the rulers). On the Data tab the first line
is the Recordsource property. What is in that property? If it's a SQL string
copy and paste it to a message here; if it's the name of a Query open the
Query in SQL view and post that text here.


John W. Vinson [MVP]