Find record in continuous subform table.

[jwleonard]

I have a parts database, part of it's function is to track main parts and sub parts. For instance, say main parts are laptops and desktops. Sub parts are displays, hard drives, keyboards, video cards, and so on. I have a form that would show all different types of main parts. It has a continuous subform that shows all the sub parts that go to the selected main part. I can easily search for a main part but need to find a way to search for sub parts.

If I am on desktop 1 all of it's sub parts are shown in the sub form and I could easily find a record currently showing in that subform. I need to figure out how to properly find a sub part that is for another main part, like one for laptop #2. I don't want the user to need to find the main part first, I want the database to go to it and select the appropriate sub part.

I have tried several different things with no luck so far. I think I need a query that will find the main part ID, go to it, and then a find record that will go to the sub part in the continuous subform. Any ideas?

 

[Oldsoftboss]

Try this. It will search a listbox, find the part in the subform.
Pardon the field names, it is a quick hack-up of another example.

Dave

 

[jwleonard]

Thanks Oldsoftboss, that will work very well. Is there a way to do this behind the scenes though? I have a search box that can search the main or sub part and would like to have the user only enter the search info in this field instead of opening another form. Thanks for that idea though, I will surely use it if there is no other choice.