General discussion


Search feature in Access form

By Aldanatech ·
How can I add a search features on Access forms. Lets say the user wants to find a record by entering first or last name or any other field to find a record either on the current or a different table. How can I do this?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by john.a.wills In reply to Search feature in Access ...

Here is one way:
Private Sub SeekByID_AfterUpdate()
Dim rs As Object
Me.Filter = ""
Set rs = Me.Recordset.Clone
rs.findfirst "[ID]=" & Str(Me.SeekByID)
Me.Bookmark = rs.Bookmark
End Sub

Collapse -

A little more help

by coire.reilly In reply to

Can you dumb this down a little? I'm new to working with Access. Does this go in a text box? If so then where should I place this code?

Thanks for your help!

Related Discussions

Related Forums