so i have a form with
4 textbox; idnum, lname, fname, dept
1 button
i need help about when I type in the idnum.Text there will be results based on the database table (ms access)and auto fill lname.Text... and if it doesn't exist there'll be a prompt.