how can i search or find a certain record through a primary key in MS Access database.
I have a database (db), composes of five field and one of them is ID (primary key), firstname, lastname, middlename and picture. I have already designed a IDFORM in form tab. Well the interface looks cool but I wanted it to search for a record in the database.
My logic is like this:
1. Once the user enters their ID number and right after they press enter, the form should automatically search/find that ID number. If the search is not successful a dialog box must be displayed informing user that ID number is not valid. If successfull, a new pop-up form will pop-out in front of user’s screen displaying all result of the query.
I have searching for this source code and until i have not found one.
An experts help is highly appreciated.