I am trying to use a form to search a table by entering text in a text box and then clicking a command button. My table will have account# and account name. User will be able to enter the account# in the text box and click on the command button. The command button will search the table and see if what input matches what's on the table. I have created some codes below, I tried it and it seems to work.. Is the codes correct tho??
However, I want to be able to open up another form called frmLogoff if what the user input matches with the table.