M MartijnAn Registered User. Local time Today, 13:55 Joined Sep 30, 2004 Messages 51 Aug 12, 2005 #1 Hi All, Does someone know how to validate data entered in textbox to a table? In other words: how to check the value entered in the textbox exists in the table. Thanks.
Hi All, Does someone know how to validate data entered in textbox to a table? In other words: how to check the value entered in the textbox exists in the table. Thanks.
FoFa Registered User. Local time Today, 15:55 Joined Jan 29, 2003 Messages 3,672 Aug 12, 2005 #2 IF 0 < DCOUNT("ColumnName","TableName","Column = '" & Me.TextBoxName & "'") then ' At least one value exist Else ' This value doesn't exist End If As one way of doing it.
IF 0 < DCOUNT("ColumnName","TableName","Column = '" & Me.TextBoxName & "'") then ' At least one value exist Else ' This value doesn't exist End If As one way of doing it.
