If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
data validation in text box
i want to enter some data in text box,But i should not enter any value in
text box,The data what i enter is should same as what i predifines by using an another table any tips on this Regards Faisal Riyadh |
#2
|
|||
|
|||
data validation in text box
Not sure if I follow but here goes. You have data in one table you want the
user to use and stay confined to. If this is the case use a combo box and set up the not in list event to control the users actions. It is considered nice to code it to allow the user to add the item to the list if it is not there if you want them to have that capability. Hope this helps -- Pete Blackburn - words to live by: "Don''t ever let somebody tell you. You can''t do something.You got a dream,You gotta protect it." Edited Quote from the Pursuit Of Happiness "Faisal" wrote: i want to enter some data in text box,But i should not enter any value in text box,The data what i enter is should same as what i predifines by using an another table any tips on this Regards Faisal Riyadh |
#3
|
|||
|
|||
data validation in text box
Deat sir,
my thanks in advance for your reply Actually i want to know that there there is any way to control text box for data entry ,like the combo box property limit to list set to true "default105" wrote: Not sure if I follow but here goes. You have data in one table you want the user to use and stay confined to. If this is the case use a combo box and set up the not in list event to control the users actions. It is considered nice to code it to allow the user to add the item to the list if it is not there if you want them to have that capability. Hope this helps -- Pete Blackburn - words to live by: "Don''t ever let somebody tell you. You can''t do something.You got a dream,You gotta protect it." Edited Quote from the Pursuit Of Happiness "Faisal" wrote: i want to enter some data in text box,But i should not enter any value in text box,The data what i enter is should same as what i predifines by using an another table any tips on this Regards Faisal Riyadh |
#4
|
|||
|
|||
data validation in text box
In the BeforeUpdate event of your textbox use the DLookup() function to
insure that the value entered is present in the table. If the value isn't found in the table Cancel = True Msgbox "Value not found! Try again!" -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200805/1 |
Thread Tools | |
Display Modes | |
|
|