Result of Text Box in Msgbox!

  • Thread starter Thread starter Jadabug
  • Start date Start date
J

Jadabug

I have a textbox names UserID, and a button that should only let
certain users access the form it is linked to. When the button is
clicked, if the user id is not listed in the if function, I would like
the msgbox to say "I'm sorry Mr./Mrs. (UserID), you do not have this
access". How do I format the msgbox to read from the textbox? Thanks!
 
Jadabug said:
I have a textbox names UserID, and a button that should only let
certain users access the form it is linked to. When the button is
clicked, if the user id is not listed in the if function, I would like
the msgbox to say "I'm sorry Mr./Mrs. (UserID), you do not have this
access". How do I format the msgbox to read from the textbox?
Click to expand...


MsgBox "I'm sorry Mr./Mrs. (" & Me.UserID & ") you . . ."
 
Back
Top