By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,270 Members | 1,582 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,270 IT Pros & Developers. It's quick & easy.

Locking Form and Subform

P: n/a
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.

May 10 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.


May 10 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.