I have a search textbox in my form. I also have, textboxes for computer name, mouse serial number, monitor serial number and phone number. While in my database, they are all reside in one table named tblComputerAsset. I am using Access for my Database.
What I want to do is when the user type for the computer name in the search text box, then if it finds the computer name exists in my database, the computer name, mouse serial number, monitor serial number and phone number from the record in my database will display all of it to my textboxes.
Thanks in advance. :)