|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 26th, 2008, 07:09 PM
posted to microsoft.public.access.forms
|
|||
|
|||
Editing in sub-form is locked
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? -- Regards, John 
|
|
#2
February 26th, 2008, 07:30 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Editing in sub-form is locked
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. -- Regards, John "John Keith" wrote: 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? -- Regards, John
|
|
#3
February 26th, 2008, 07:54 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Editing in sub-form is locked
On Tue, 26 Feb 2008 11:09:00 -0800, John Keith
wrote: 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. -- John W. Vinson [MVP]
|
|
#4
February 26th, 2008, 08:24 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Editing in sub-form is locked
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 -- Regards, John "John W. Vinson" wrote: On Tue, 26 Feb 2008 11:09:00 -0800, John Keith wrote: 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. -- John W. Vinson [MVP]
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
