Now you see them, now you dont Buttons.

B

Bret A.

Hi All, I have a RMA form that I want a few buttons to be hidden until an
Authorization Code is entered by a manager. Question 1: Should I use a field
called Authorization # in the table for the code or is thier a better way.
Question 2: What code can I use and where will it go to test for the code and
show the hidden buttons?

Thanks,
Bret
 
B

bhicks11 via AccessMonster.com

Is it always the same authorization code? If so you can hard code it. So I
would have an unbound control on the form with the Input Mask set to Password.
In the OnExit even of the control you can put the code:

If me.unboundcontrol = "WhateverAuthorizationCodeYouDecide" Then
me.whatevercontrolyouwantvisible.visible = true
else
me.whatevercontrolyouwantvisible.visible = false
End if

Make sure you set the default value of the controls to visible=false.
Replace the names with the real names of the controls.

Bonnie
http://www.dataplus-svc.com
 
Top