User Forms & Checking Input
Hi please help...
I have a user form in Excel which collates all the information I need, and then updates into a table in an access database.
I am trying to understand that when I input a job number in the form that it then runs a query to the database and finds out if that job number exists in the table already, and if so then it alerts me to say allready in database. How can I do this?