Search function for Subform on form

[snoop832]

Hello new here....

I'm new to access so please be patient. Thank you in advance.

I'm looking for a VBA code that I can place in my form to be able to search my parts table in the subform section on my form.

I have been able to setup a basic search function on the form but not the subform. I have searched and have no idea what codes need to be added in the code section.

Any help would be deeply appreciate it.

PS. is there any kind of book or website that would tell me the definitions of certain characters in a code? example: ! "*" etc. [ ]

Thanks ANdy

 

[Ranman256]

I don't think you need code,
You just need a query that uses the master form key as criteria,
And any other items on the form to filter the query.

 

[snoop832]

Thanks everyone for the info.... I'll have to watch the videos.
Here is a snap shot of what I'm trying to do. Basically trying to have two different tables in 1 form. I want to have a search function for the subform area. I set up a text box and a button but I can't figured out how to link it to only the subform area.

Im sure you guys can help.

Thanks a bunch Andy

 

[snoop832]

Hi Uncle,

I'll try and explain.... Looking at the main form I will be adding parts that were used to a different table called used parts table (top of form). Now for the sub-form area I would just like to use it as a quick part search prior to adding any kind of parts to the used parts main form/table.

I just want to be able to look up parts for info and enter it above. This is why I want a search button to search the sub-form area below. This is for reference/view. I really don't want to open up a separate form just for that.

Thanks!