Error message in sub-form (Can't assign value to object)

[HacH]

Hi,

I have developed a simple Access database which has two forms. I have also created a third form, which has a tab-control and the two original forms as sub-forms on it. The forms seem to work okay on their own however when I try to input a new record from the sub-form it outputs an error message "You can't assign a value to this object" and also gives the following reasons:

1) The object may be a control on a read-only form
2) The object may be on a form that is open in design view
3) The value may be too large for this field

None of the fields on the form are "required" fields and the form is not open in design view. Can someone please help me with this?

Many Thanks,

Mamoon

 

[jebry]

Hi!

What are the control sources of the subforms?



Jeff Bridgham
Purdue University
Graduate School
Data Analyst

 

[jebry]

Hi!

Obviously I meant the record source of the subforms.

OOPS!


Jeff Bridgham
Purdue University
Graduate School
Data Analyst

 

[HacH]

Jeff,

I'm not 100% sure about what you mean by "record sources of the subforms" as I am fairly new to Access..The sources in the subforms are from the two original forms that I have developed. The first forms is "Frm-AtRiskDetails" and the second is "Frm-ContactDetails". The third form which contains the tab control has both of these forms in it and is seperated into two tabs, with the two forms.

Records in each of the subforms are related to that particular form and the tables have a 1:1 relationship.

Please let me know if you require any other info.

Thanks,

Mamoon