Creating fields like gateways, when met, unlock next step

A

Aso

I am researching how to create "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,
 
K

Keith Wilby

Aso said:
I am researching how to create "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,

In the current event of the form, put something like

If Me.txtSomeTextBox = "some value" Then
Me.txtSomeOtherTextBox.Enabled = True
ElseIf
Do other stuff
Else
Do other other stuff
End If

Your "keyholder" will have the permission to set "some value".

Keith.
www.keithwilby.co.uk
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top