newbie question - forms

[etk]

I have a table of accounts with the following fields

Account_ID
First_Name
Last_Name
Institution
Account_type

I have created a form that allows me to enter in new records via text fields (list box in the case of Institution).

What I want to do is to have a query search an existing record as entered into the form and then pass back all the existing info from the record so that a user can modify the information and update the record. The user should only have to use the form as they will have no or limited understanding of DBs.

Any help is appreciated. I am rather new to DBs.

 

[John Big Booty]

Welcome to the forum.

Perhaps the search form posted here will give you some ideas.