Locking Form and Subform

[Moha]

I have form Orders and Subform Technical info. The Ordrs form is
connected to query (multiple table) and the Technicl subform is
connected to one table. I have divided the technical table into
multiple subforms and each subform has its owm fields according to the
workflow in the company. Creating technical information is first form,
then filling dispatched serial numbers to the dispatched material is
another subform and then adding field measurements is another form. All
these subforms are related to one technical order in the order table. I
want to know how can i lock the fields per action or workflow. It would
be helpful if you can elabrate with examples. Thanks.

[Tom van Stiphout]

On 10 May 2006 02:43:09 -0700, "Moha" <me*******@gmail.com> wrote:

I'm thinking you mean to say that once the first subform is filled out
(and the status is set to the next stage), the data cannot be modified
anymore. That sounds like one line of code:
Me.AllowEdits = (Status <> FirstStageStatus)
You may need to put this line in several events. Quick and Dirty would
be to put it in Form_Current.

-Tom.

I have form Orders and Subform Technical info. The Ordrs form is
connected to query (multiple table) and the Technicl subform is
connected to one table. I have divided the technical table into
multiple subforms and each subform has its owm fields according to the
workflow in the company. Creating technical information is first form,
then filling dispatched serial numbers to the dispatched material is
another subform and then adding field measurements is another form. All
these subforms are related to one technical order in the order table. I
want to know how can i lock the fields per action or workflow. It would
be helpful if you can elabrate with examples. Thanks.