Editing in a form

[Dan]

I have a form with a subform. The subform is in DataSheet format on another
form. The parent form has text boxes for each Item of the subform listed so
they can edit the fields.

The subform is at the top so the user can scroll through the items then when
they click one the main form fields are populated for the user to edit. But
when they try to change something I get the error 'Control can't be edited;
it's bound to the expression '[PRODUCT TABLE].Form!DELIVERY'

The main for is 'Form3' the sub form is 'PRODUCT TABLE'.

I've tried Form_Form3.AllowEdits = True no help.
I've tried Form_PRODUCT TABLE.AllowEdits and it gives an error ( I think
because of the space in "PRODUCT TABLE")

Any help would be great

Dan

 

[Rick Brandt]

I have a form with a subform. The subform is in DataSheet format on another
form. The parent form has text boxes for each Item of the subform listed so
they can edit the fields.

The subform is at the top so the user can scroll through the items then when
they click one the main form fields are populated for the user to edit. But
when they try to change something I get the error 'Control can't be edited;
it's bound to the expression '[PRODUCT TABLE].Form!DELIVERY'

The main for is 'Form3' the sub form is 'PRODUCT TABLE'.

I've tried Form_Form3.AllowEdits = True no help.
I've tried Form_PRODUCT TABLE.AllowEdits and it gives an error ( I think
because of the space in "PRODUCT TABLE")

Read the error message again. A *control* can contain either a field
reference or an expression as its ControlSource. It will only be editable
when it uses a field name as its ControlSource. When an expression is used
it will always be read-only.

Some place on your form you have a control that has "[PRODUCT
TABLE].Form!DELIVERY" as its ControlSource property. As such it cannot be
edited.