code for finding record in a form

[Prakashpdl]

Hello,
I am novice to access. I have a form and few subforms as tabbed pages in the main form. I have a separate page as search page that consists of searchbox and searchlist. When I type a name in searchbox, there is listing of matched names in listbox. Now I want to click one of the names in list box so as to open/go to the record corresponding to that name in the main form. Is there any simple code or way to do that? Please help.

 

[theDBguy]

Hi. You would normally just filter the form to the matching value from your list.

 

[strive4peace]

hi @Prakashpdl ,

here is a page with code to find a record that also explains how it works:

VBA > Form > Find Record
http://msaccessgurus.com/VBA/Code/Form_FindRecordN.htm

 

[Prakashpdl]

Thanks for code. I have a form (Sform) in which there are Searchbox (Sbox) and Searchlist (Slist). When I search for a name it shows list of matching names. Until this step I was able to accomplish. Now I want a code by which if I click (or double click) a name of my interest listed in the listbox, I am able to view its record (The record lies in another form Form2). Can you please help.

 

[Gasman]

I would use the DoCmd.OpenForm and in the Where argument supply the key of the record you double clicked.?

https://docs.microsoft.com/en-us/office/vba/api/Access.DoCmd.OpenForm

 

[strive4peace]

@Prakashpdl, if you need help implementing the code, please post a stripped down version of your database and specify exactly what to click and pick and what should happen, thanks!