Rick Stanich
King and Supreme Ruler
- Local time
- Yesterday, 22:49
- Joined
- May 13, 2009
- Messages
- 93
(Solved) Using a textbox on a form with a table
Hi, Im quite new to Access and database design allthough I have practical VBA and VB experience, I notice I dont have enough to do minor techniques in Access.
I have a textbox on a userform that a user will type in a value and I would like to check if the value is in a table, if not prompt the user and return focus to the textbox.
Future case would be to find a "Like" condition and let the user select from any available choices from the table. But I will settle for simply checking against a table.
I have searched and still am, I don't know the correct language to format my search's; thus it takes me a while to find things.
Any hints, tips and or examples are appreciated.
Hi, Im quite new to Access and database design allthough I have practical VBA and VB experience, I notice I dont have enough to do minor techniques in Access.
I have a textbox on a userform that a user will type in a value and I would like to check if the value is in a table, if not prompt the user and return focus to the textbox.
Future case would be to find a "Like" condition and let the user select from any available choices from the table. But I will settle for simply checking against a table.
I have searched and still am, I don't know the correct language to format my search's; thus it takes me a while to find things.
Any hints, tips and or examples are appreciated.
Last edited: