Access find record

Gaverick

Gaverick

Gaverick

Associate
Joined
21 Jan 2006
Posts
2,171
Location
Seaham, Co. Durham
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?

accessdb.jpg
 
Gaverick said:
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?

accessdb.jpg
Click to expand...


You could do an SQL "like" statement query

so have a text button on your front page and a text box and make it work like Google and open "FRM_newform". ... where FRM_newform is a copy of your existing form but linked to the query rather than the original table,

Cheers

David
 
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
 
Hi,

This could be possible to do using the query you created.
What you would need to do is go into your visual basic code for that form and find the event for the button, then add the following:

Code: 
Me.RecordSource = "Name of your query here"

This should use your query and populate the textboxes on the form.
 
You must log in or register to reply here.
Back
Top Bottom