Lock one form from another form

[banpreet]

Hi guys, I posted before but didn't state my problem clearer because I noticed I had a different problem.


I have a combo box on a form that has three options, "Draft", "Pending", and "Final" which decides the status of a form because of an approval process, and I have three of the same forms but with different stuff on each because of an approval process of the forms. The first form is filled out by the customer then gets sent to the first approver, the combo box which is locked is automatically on "draft" for the status, because the customer does not have the option to change the status. The approver will open up the same form but have the option to change the combo box to "Pending", once the approver hits pending for the status, he sends it the next approver who opens up the same form but changes the status to "final". How do I code it if possible that when the first approver changes the status to "pending" it locks the first form filled out by the customer, and when the second approver changes the status to "final" it will leave the first form locked as well.


Thanks, all help appreciated!

[Bulzie]

Kinda of confusing, you say you have 3 forms but then the approver opens the same form, etc.? Can you give more detail and list out all the forms and which one has combo boxes, etc. But you can put code in one of the form events or on the AfterUpdate of the combo box to lock fields or a form.

If me.combobox = "Draft" then Forms![CustomerForm].Locked = True

[banpreet]

All the forms have combo boxes, on the first form it is locked though on draft, because it can only be changed by the approver. The approver then opens his form which is basically the same information which the customer filled out but now has another box that he can sign which the customer could not see before, and he has the option to change the combobox value to pending, then same thing for the last approval, except he switched it to final. But once the approver hits pending of final it will lock the first form the customer filled out, so I basically have three copies of the same form but each person has different stuff on each. Thanks, hopefully it makes sense.

[Bulzie]

I assume you are doing this so that once the review process starts(it is put in Pending or Final status), you don't want the customer to go and change anything on the form right? If so then I think you need to add a condition to the first form to check that status field. If it is Draft, then the form can be edited. If it is Pending or Final, it cannot be edited. If that is how it needs to work, then on the Customer form in the OnOpen Event, put:

If me.Status = "Pending" or me.Status = "Final" then

Forms!frmCustomer.allowEdits = False

End If

[banpreet]

Ok but this will only lock the customer form then, right, the approver forms would still have access to change anything right on their form right? thanks for the help!

[Micron]

Agree with the proposal. However, you cannot check the value of a control in the Open event. It has to be in the Load event.

There should only be one form if the only difference is that some fields are not visible according to your user level. If you had to add one field to the first user's data, you'd have to redesign 3 forms. That's not a great idea. When locking (or not) a form, that is the time to show or not show controls.