im trying to compare a value that a user can input in a txt box to a record in a database.
for example i have a txt box which has id as txtStudId. now i have a db which has already been linked to the form using the access data source control.
in the database, there exists a student table, where the Stud_ID field contains student id's against which i have to compare.
so when i enter say s112233 in the txt box nd click on a button, say btnLogin, how do i compare this with Stud_ID in the student table?
im lost.....any help will be appreciated.