READ ONLY ERROR

[Guest]

Hello,
Does anyone know how I can fix this.....

It means that the control is set to read only (Enabled = No); that the
Form is read only (Allow Edits = No); or that the subform is based on
a Query which is not updateable.

I have a subform on my main form and when i go to select a drop down from
that subform...the read only error comes up....the information is stored,
however the error still comes up????

help
RW

 

[Allen Browne]

If you open the main form with Allow Edits set to No, the subform will be
locked.

The subform also as its own AllowEdits property.
Also make sure the subform's RecordSourceType property is Dynaset.

If the subform is based on a query, try running the query directly from the
Database window. Can you edit values there? If not, you won't be able to
edit in the form based on the query either. For a list of things to look for
to fix the query, see:
Why is my query read-only?
at:
http://allenbrowne.com/ser-61.html

If you can edit in other controls, just not in the combo:
a) Make sure its Enabled property is Yes, and Locked is No.
b) Temporarily remove any code from the combo's events.
c) Make sure the combo's RowSource is valid, and the Bound Column is the
correct one.

 

[Guest]

Thanks man....I will give that a try

If you open the main form with Allow Edits set to No, the subform will be
locked.

The subform also as its own AllowEdits property.
Also make sure the subform's RecordSourceType property is Dynaset.

If the subform is based on a query, try running the query directly from the
Database window. Can you edit values there? If not, you won't be able to
edit in the form based on the query either. For a list of things to look for
to fix the query, see:
Why is my query read-only?
at:
http://allenbrowne.com/ser-61.html

If you can edit in other controls, just not in the combo:
a) Make sure its Enabled property is Yes, and Locked is No.
b) Temporarily remove any code from the combo's events.
c) Make sure the combo's RowSource is valid, and the Bound Column is the
correct one.