C
Coleen
The Mainform has a link to 3 tables, and has a subform imbedded that is
based entirely on a different table with the table linked to the main table
by two ID's - the Primary in the main table and the foreign key of the table
the subform is based on.
Neither table is being updated with the Id of the other table when the
subform entry is complete AND I am getting this error:
"You can't assign a value to this object.
*The object may be a control on a read-only form.
*The object may be on a form that is open in Design view.
*The value may be too large for this field."
This happens on the selection of the first drop-down inside the subform. It
is a drop-down box with a value list of Yes/No. I do not have the object
open in design mode, and how could it be too large - the field is a text
field with 255 characters - way bigger than I need for yes/no text! I'm
thinking of changing this back to check boxes, but the user said that they
like the drop-down better. I'm really at a loss on how to get the
subform/form to work together and store the id's - and now I haven't the
foggiest why I would be getting this error. I'm using Access 2000, and I
admit it's been about 5 years since I've done any major programming in
Access, but Foreign/primary keys should populate!
Please, any help that can be offered is VERY much appreciated!
TIA,
Coleen
based entirely on a different table with the table linked to the main table
by two ID's - the Primary in the main table and the foreign key of the table
the subform is based on.
Neither table is being updated with the Id of the other table when the
subform entry is complete AND I am getting this error:
"You can't assign a value to this object.
*The object may be a control on a read-only form.
*The object may be on a form that is open in Design view.
*The value may be too large for this field."
This happens on the selection of the first drop-down inside the subform. It
is a drop-down box with a value list of Yes/No. I do not have the object
open in design mode, and how could it be too large - the field is a text
field with 255 characters - way bigger than I need for yes/no text! I'm
thinking of changing this back to check boxes, but the user said that they
like the drop-down better. I'm really at a loss on how to get the
subform/form to work together and store the id's - and now I haven't the
foggiest why I would be getting this error. I'm using Access 2000, and I
admit it's been about 5 years since I've done any major programming in
Access, but Foreign/primary keys should populate!
Please, any help that can be offered is VERY much appreciated!
TIA,
Coleen