Access find record

[Gaverick]

I've got an access database, and on one of my forms i want a button where you type in the name of a customer and it then brings up that customers details in the form. Currently i have a button linked to a query, it finds the user but opens it up in a table instead of the form. Can anybody tell me how to get it to open in a form?

 

[Gaverick]

i kind of get your drift but have no idea how to do it lol, step by step instructions?

sorry about this, last year the project was programming java and vb, then in the final year it's access lol, whats up with that, i much preferred the proper programming

 

[Gaverick]

haha thanks you legend, works just how i wanted it to