So here is my problem

I have a access database called cust.mdb and I want to design a form that allows the user to input a name in a textbox and then search a database to find the address and state associated with that name and have those displayed in labels right under the textbox. The database would include the name of a person, address, and state.

My problem is a few things.

It seems that you need to assign a parameter before filling in the database. How can this be done? I tried it out and got a fill error everytime.

Also, in order to search the database, do you need to do a do/loop loop to find a match of the textbox to a value in the database? This is what is confusing me.


Please help.

Thanks

Daron