I am building a search form

[NithinR]

I am new to access.
Please help me...

I am using access 2000. I have an access form that is bound to the table employees. The employee table has fileds for lastname, firstname, age, etc.

I want to build a search function on the form. I added a text box and a search button. When the user enters the last name(or part of the last name) in the text box and clicks the search button, I want to display all matching records(many employees have the same last name)..in a list box.

The user can select the emplyee and that record is loaded on the form.

Can someone help me with this?

Please include all code as I am new to access.

Thanks in advance.

[puppydogbuddy]

Here is a link to a "How To" that includes a downloadable demo with the source code.

http://www.databasedev.co.uk/list_box_searching.html

[lee123]

Or you could do this to find a certain name:

private Sub Text1_Afterupdate()
 
     Dim search As String
     Search = Text1
     If search = "" or IsNull(search) Then Exit Sub
     Docmd.GoToControl "What Ever your Field Is"
     DoCmd. FindRecord Search, Acanywhere, False, Acsearchall, , accurrent, True
     Me.Refresh
 
End Sub

lee123

[Scott Price]

Lee, thanks for your answer, but could I ask you to use the [code] tags provided?

As a full member, and especially with the number of posts that you have, this is not asking very much! It's quite simple to add them... Simply select your code in the reply window, then click on the # icon on the top of the reply window.

Thanks!

Regards,
Scott

[lee123]

yea sorry i always forget to do that when you see somrthing you can help with it just kida slips your mind sorry scott price

lee123