By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,162 Members | 1,050 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,162 IT Pros & Developers. It's quick & easy.

Validation code not to to accept entries not found in combo list

P: 2
I am designing a project in access. I have designed an input form with a combo box that is bound to a field list from another table.

I don't want the textbox to accept any item which is not in the bound field on validation.

Can any one help with a soluttion

Thx
Jul 22 '13 #1
Share this Question
Share on Google+
3 Replies


Rabbit
Expert Mod 10K+
P: 12,369
If you want to limit it to the combo list, then just use the combo list. I don't understand why you're bringing an extra textbox into the equation.
Jul 22 '13 #2

P: 2
My difficulty is that I have 2 tables say tbl1 and tbl2. My form is designed to update records in tbl1 .There is a combo box on my form which is linked to a list of names from a field in tbl2.

I want to have an error msg if I type any name which is not in the name field on table 2.

sorry if I was not detailed enough. This is my first ever project in access.
Jul 22 '13 #3

Rabbit
Expert Mod 10K+
P: 12,369
I understand. There's no need for an extra textbox. Just use the combo box.
Jul 22 '13 #4

Post your reply

Sign in to post your reply or Sign up for a free account.