Entering Data in Subforms w/ Main form locked

R

rgrantz

I have a tri-level form setup:

-Main Form (can't add new records)
- Sub Form (Can add new records, but not delete or modify existing records,
linked Child/Master w/ child's default value set to Main Form's Master value
for when new records are added)
- SubSub Form (Can add new records, but not delete or modify existing
records, linked Child/Master w/ child's default value set to Sub Form's
Master value for when new records are added)

What happens is that I cannot add records in the subsubform when the
SubForm's "AllowEdits" property is set to "No". I need to set the SubForm's
"Allow Edits" property to "yes" in order to have the ability to add records
in the SubSubForm.

I only want people to be able to add new records in both the SubSubForm and
the SubForm, and not be able to add records in the Main Form. However, I
still want the existing records to show up for viewing. In other words,
everything works exactly the way I want it to when I have the SubForm's
AllowEdits property set to Yes, but I need it to be set to No.

Is this possible? I can't lock all the fields in the Sub and SubSubForms,
because people need to be able to enter new data in them when they add a
record.

Thanks for any help.
 
Top