Creating "key" fields when met, unlock the next step...

[Aso]

I am researching how to create veritable "gates" in a database so that when
someone initilializes the process filling out a form, they cannot progress
beyond a certain point in the process until a specified field is
"electronically" signed by the "keyholder" person authorized to approve
progression to the next step. The "next step" could be gaining entry into
another form or subform. I've not been able to come across anything helpful
yet. Any help is much appreciated.

Thank you in advance,

 

[Mike Painter]

I am researching how to create veritable "gates" in a database so
that when someone initilializes the process filling out a form, they
cannot progress beyond a certain point in the process until a
specified field is "electronically" signed by the "keyholder" person
authorized to approve progression to the next step. The "next step"
could be gaining entry into another form or subform. I've not been
able to come across anything helpful yet. Any help is much
appreciated.

Thank you in advance,

A simple password on the forms is one way. The boss just enters the proper
password.
This works:

If InputBox("Enter password") = "TheSecretPassword" Then
DoCmd.OpenForm "TheNextForm", acNormal, "", "", , acNormal
Else
MsgBox "Wrong password"
End If

 

[Aso]

My apologies Mike, for some reason this site was not and has not been
functioning for me for quite some time, I am truly surprised that I even got
this to post.

Well i wasnt trying to lock down the entire form and PW protect. I need the
password to lock subsequent fields down and once they have been unlocked I
want them to remain unlocked. There will be a series of these as they are
part of a process with many steps. I hope i have explained myself clearly
enough.

Thank you,
Aso =)

 

[Mike Painter]

You can set the locked property to make a field read-only.
I don't know of any real secure way to provide password protection at the
field level.
You could store the password(s) in a separate table and set it's visible
property to false.
A password field would be added to your table and you can mask this with
"***" or something.
In the on-open event for the form and the afterupdate event of the password
field
lookup the password on the form with teh password in the table and set
Me.Yourfields.locked = false
for all of them.