Any help would be appreciated to solve the following simple problem that
I will describe.
***
There is a form called "red chocolate form".
The form has a particular subform field that has a checkmark box that is
selectable as on or off (on if there is a checkmark inside it).
The table that contains the data for the form is known as "red chocolate
table".
The table has a field name known as "sweetener".
The datatype for the sweeter field is Yes/No.
Thus if there appears a checkmark in the form "red chocolate form" where the
checkmark box is, this means the record contains sweetener".
**
Right now if I select the field name known as "sweetener" from within the
design view of my table known as "red chocolate table", I can see the
General Properties has as the Default Value of "True".
It used to be "False", however I changed it to True so that everytime a new
record was added using a different form, the "sweetener" would be selected
as default.
The problem right now is that everytime a new sub record is added, I don't
want
"sweetener" selected by default. Its acceptable if everyime a primary
record is
added sweetener is selected by default, however not when a record is added
from the subform.
The form that indicates whether or not there is a sweetener contains a
subform for
the same primary record whereby additional information can be added via the
subform, and since the subform contains the checkbox for "sweetener" within
the
form-- it is automatically set to be true and is selected.
The primary information has a ID number that remains the same even though
different subform data can be added, thus maybe somehow if the validation
rule
or default value contains an expression that monitors the ID number to see
if its
the same ID number as the previous entries within the ID numbers then it
won't
select "true" by default.
I only want it to be true if its an entirely new primary record that is
added to the
table, and not a new subform record. Is there any rule or expression I can
type
into the default value line or validation rule for the field name sweetener
?
From the form level there should only be a maximum of 1 true value per ID
number, unless ofcourse its modified from the table level.