Avatar of angie_angie
angie_angie asked on

Validation Rule for TextBox in a Form

I have a Form where I can enter the "UserID" in a TextBox so the related info will be displayed.
I want to add Validation Rule to this TextBox. If the UserID entered is not in the Field [UserID] of the Table [tblUser], a Validation Text will pop out.
I tried a few times to use expression builder, but everytime got error. Could someone help me on that?
Thanks!
Microsoft AccessSQL

Avatar of undefined
Last Comment
peter57r

8/22/2022 - Mon
SOLUTION
peter57r

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
frankytee

following from Peter57, enter YES in the "limit to list" property of the combo box (under the data tab).
ASKER
angie_angie

A ComboBox can only allow me to choose the data from the drop-down list right?
But what I want is to ENTER the UserID and see that user's info.
Can ComboBox do that? Thanks.
ASKER CERTIFIED SOLUTION
frankytee

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Your help has saved me hundreds of hours of internet surfing.
fblack61