Is there a way to have a subform that is editable when composed but not editable once it has been saved?
I can not use a seperate form with computed fields because the fields are in the subform that is shared on all the forms in the DB.
Subject: Couple of ideas…
Shawn,
Use either a controlled section or a computed subform. Computed subform would swap out the subform for a different computed for display model depending on whichever parameter you wanted to use, ie. @IsNewDoc…
- Matt
Subject: RE: Couple of ideas…
Thank you for the advise, however…
wouldn’t all of these suggestions require, at least, a second subform?
I will do that if I have to but I was wanting to have only one subform so if any fields change I would only have to update them in one place.
Subject: RE: Couple of ideas…
No; a controlled access section does not require a second subform; nor does using hide formulas to hide the editable field and display a CFD field with a copy of the value.
Subject: RE: Force non-editable subform ??
There are many ways. It’s a novice question. Read about hide formulas. Read about computed subforms. Read about access controlled sections. Nobody would suggest using a separate form with computed fields.