Search from main form multiple subforms

[craigprice]

I'm looking for a search function that will allow someone to search from a main form which contains 3 subforms that all are of combo boxes with different parts of information from a query.

For Example:

Main_FORM
Service_SUBFORM
Callout_SUBFORM
Contacts_SUBFORM

I want to have a textbox on Main_FORM that when the "search" is entered in here it will search on all three of the subform combo boxes, acting as a filter, I have tried to do this with this; http://www.access-programmers.co.uk/forums/showthread.php?t=188663 but I seem to be struggling in getting it to work correctly.

Is anyone able to point me in the right direction for doing this?

The reason I need different columns of the query in different subforms is that when you click a particular row it goes to a URL related to the column that is clicked.

Thanks in advance.

 

[craigprice]

The main form uses the same query for it's record source and then each of my subforms are built basically to show combo boxes listing specific columns from the query/table.

For example the table is "callouts"

This has an application name, the service, the support team and a like to web details of them.

Subform one displays support team name and then when clicked links to their rota.
Subform two shows what service/application it is and links to their page describing it.
Subform three is an additional part to mail the team by clicking the relevant item

this is why I need the three separate subforms but I want to be able to perform a search which filters all three subforms so you see the single line of information, if that makes sense?

 

[craigprice]

Yes that is correct