Hello!
I have 3 tables that are supposed to be related and I have put them on a form.
Table 1 : has demographics info (dob, school, etc.) Pk is a client ID
Table 2 : has address info for a particular client (they can have many addresses) This pk is autonumber
Table 3 : has the address type information (legal caregiver, child's address, etc) This pk is an Autonumber.
Table 2 has a lookup to table 3 in order to have a drop down menu of the type of address.
Now, a "demographics" form (table 1) was created with a subform "address" (table 2 that already has lookup to table 3).
Now I can add, change information to the form, but not to subform. It tells me "I can't assign a value to this object" because: "the object may be a control on a read only form, the object may be on a form that is open on design view, the value may be too large for this field"
Please help...I have tried everything (I think) and could not fix it.
Thank you!!
I have 3 tables that are supposed to be related and I have put them on a form.
Table 1 : has demographics info (dob, school, etc.) Pk is a client ID
Table 2 : has address info for a particular client (they can have many addresses) This pk is autonumber
Table 3 : has the address type information (legal caregiver, child's address, etc) This pk is an Autonumber.
Table 2 has a lookup to table 3 in order to have a drop down menu of the type of address.
Now, a "demographics" form (table 1) was created with a subform "address" (table 2 that already has lookup to table 3).
Now I can add, change information to the form, but not to subform. It tells me "I can't assign a value to this object" because: "the object may be a control on a read only form, the object may be on a form that is open on design view, the value may be too large for this field"
Please help...I have tried everything (I think) and could not fix it.
Thank you!!
