Editing in sub-form is locked

J

John Keith

I have a sub-form that when loaded seperately allows edits. The underlying
query also allows edits to update the base table. The query contains simple
references no calculated fields or multi-join situations.

However when viewing the mainform(w/sub-form too), the textboxes are locked
(I.E. clicking on them is not registered).

Properties attached to the sub-form:
Form property Allow Edits: yes (Additions, Deletions are both no, I only
wish to allow changes to existing table data)
TextBoxes for fields that I want to edit, Enabled: yes (some of the
Textboxes ARE disabled, greyed-out, on fields that should not change)

What is preventing the form from allowing edits on the fields that have
Allow Edits: on?
 
J

John Keith

Additional info:
I noticed that the sub-form's scroll bar is ignoring mouse clicks too. On a
record key that returns multiple rows in the sub-form seem to Load ok, but I
can not scroll down to see them.

It's as if the sub-form(form level properties) are completely
locked/disabled eventhough the properties are seemingly set to allow edits.
 
J

John W. Vinson

I have a sub-form that when loaded seperately allows edits. The underlying
query also allows edits to update the base table. The query contains simple
references no calculated fields or multi-join situations.

However when viewing the mainform(w/sub-form too), the textboxes are locked
(I.E. clicking on them is not registered).

Properties attached to the sub-form:
Form property Allow Edits: yes (Additions, Deletions are both no, I only
wish to allow changes to existing table data)
TextBoxes for fields that I want to edit, Enabled: yes (some of the
Textboxes ARE disabled, greyed-out, on fields that should not change)

What is preventing the form from allowing edits on the fields that have
Allow Edits: on?

Does the mainform itself allow edits? If not, the subform will also be
blocked. Also check the Enabled property *of the Subform control itself* on
the mainform.
 
J

John Keith

Problem solved!

It was a little weird to find the right property page to change that.

I had to rt-click on the grey area of the MAIN-form, then use the drop down
to find the FORM page of the sub-form, enabled was set to no
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top