S
steve
I have a subform in a subform. Whenever I try to enter
data in the 3rd level form I get the following error
message: "This property is read only and cannot be set."
However, I am able to enter data.
The 2nd and 3rd level tables are linked by 3 fields, 2 of
these fields are correctly filled in the 3rd level table
when I enter data. The 3rd field is not.
I have checked the properties of the form and they are set
to data entry = yes and edits = yes. I've done this type
of subform data entry with many other tables and never had
a problem, but I have never done 3 levels of subforms.
Here's a more detailed explanation and an example:
Table 1 is related to Table 2 on fields Date and Plot.
Table 2 is linked to Table 3 on Date, Plot and Count.
There are multiple plots surveyed on a given date and
multiple counts for a given plot, so I cannot make these
primary key fields (no duplicates allowed).
In table 1 (parent form), I enter date, plot number and
some other environemental data.
In table 2 (subform 1), I enter count number and some
other data specific to that count
In table 3 (subform 2), I enter species observed during
the count and additional data about each observation.
When I enter records in the subform 2, the count number
shows up as 0 in table 3.
Note if I enter data via the table, starting with table on
and click on the sublevels to table 2 and 3, I have not
problem. This only occurs when I enter data via the forms.
Any suggestions?
data in the 3rd level form I get the following error
message: "This property is read only and cannot be set."
However, I am able to enter data.
The 2nd and 3rd level tables are linked by 3 fields, 2 of
these fields are correctly filled in the 3rd level table
when I enter data. The 3rd field is not.
I have checked the properties of the form and they are set
to data entry = yes and edits = yes. I've done this type
of subform data entry with many other tables and never had
a problem, but I have never done 3 levels of subforms.
Here's a more detailed explanation and an example:
Table 1 is related to Table 2 on fields Date and Plot.
Table 2 is linked to Table 3 on Date, Plot and Count.
There are multiple plots surveyed on a given date and
multiple counts for a given plot, so I cannot make these
primary key fields (no duplicates allowed).
In table 1 (parent form), I enter date, plot number and
some other environemental data.
In table 2 (subform 1), I enter count number and some
other data specific to that count
In table 3 (subform 2), I enter species observed during
the count and additional data about each observation.
When I enter records in the subform 2, the count number
shows up as 0 in table 3.
Note if I enter data via the table, starting with table on
and click on the sublevels to table 2 and 3, I have not
problem. This only occurs when I enter data via the forms.
Any suggestions?