mapping of query result to access forms

[abhishekdhal]

I want to create a form which is linked to a table.I want to have an extra field "search" so that I can find the desired person...the search textfield will
have a corresponding button in it so that it can run a query which will show the result in the respective form fields related to the search.

Eg.

Form has 2 fields name ,id
in serch i want to enter the corresponding name to get the employee id...
I want the query to be specific like'abhishek' names may be many so it should show all the enteries related to the name 'abhishek'

[puppydogbuddy]

I want to create a form which is linked to a table.I want to have an extra field "search" so that I can find the desired person...the search textfield will
have a corresponding button in it so that it can run a query which will show the result in the respective form fields related to the search.

Eg.

Form has 2 fields name ,id
in serch i want to enter the corresponding name to get the employee id...
I want the query to be specific like'abhishek' names may be many so it should show all the enteries related to the name 'abhishek'

Try the code below. Don't forget to replace object names used for illustrative purposes with the actual names of the objects in your application.

' Chr(42) is ASCii for the wildcard symbol *
' Assumes that Name and ID controls on the form are bound to the fields in the table
' assumes that the search textbox (txtSearch) on the form is unbound

Private Sub btnSearch_Click()      'search button
Dim strSql As String
 
strSql = "Select [Name], [ID] From YourTable Where [Name] Like '" & Chr(42) & Me!txtSearch & Chr(42) & "'"
 
Me.RecordSource = strSql
 
End Sub