Creating fields like gateways, when met, unlock next step

  • Thread starter Thread starter Aso
  • Start date Start date
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,
 
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,
Click to expand...

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
 
Back
Top