C
Crispywafers
Hi,
I have a main form (Student) and a subform(Parents). Because multiple
unique students can have the same parent record (siblings) the
ParentID is also present in the Student Table so relationships work.
Everything works fine until a new Student record is added. First you
fill in the Student Form, a StudentID is generated, then when you
click on the Parents Subform (I'm using Tab Controls)... I get the
error "Montessori School Database can not find Macro '.'". If you
click Okay and get past that the Parent's subform appears and you can
fill in information.
THEN when you first try to enter information into the parents subform
I get the 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."
Next if you click past THAT. It lets you enter information into the
form-- and the autogenerated ParentID appears in the ParentID field.
Finally when your done, you close the forms. No errors.
If I go look into the tables... Information that you typed in appears
in the appropriate tables. However, the ParentID that was
autogenerated was not also inserted into the Student table-- only the
Parent Table-- so no relationship between the two works.
HELP! Please help!
Abby
P.S. I have checked the parents subform properties and Data Entry is
set to yes, as well as allow edits, deletions, and additions.
I have a main form (Student) and a subform(Parents). Because multiple
unique students can have the same parent record (siblings) the
ParentID is also present in the Student Table so relationships work.
Everything works fine until a new Student record is added. First you
fill in the Student Form, a StudentID is generated, then when you
click on the Parents Subform (I'm using Tab Controls)... I get the
error "Montessori School Database can not find Macro '.'". If you
click Okay and get past that the Parent's subform appears and you can
fill in information.
THEN when you first try to enter information into the parents subform
I get the 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."
Next if you click past THAT. It lets you enter information into the
form-- and the autogenerated ParentID appears in the ParentID field.
Finally when your done, you close the forms. No errors.
If I go look into the tables... Information that you typed in appears
in the appropriate tables. However, the ParentID that was
autogenerated was not also inserted into the Student table-- only the
Parent Table-- so no relationship between the two works.
HELP! Please help!
Abby
P.S. I have checked the parents subform properties and Data Entry is
set to yes, as well as allow edits, deletions, and additions.