Search Box on subfrm

[libraccess]

Hi have a search box on a subform (looking for Assets by an Asset ID no)
SELECT tblAsset.IDAsset, tblAsset.A_Co_Code, tblLocation.Location
FROM tblLocation INNER JOIN tblAsset ON tblLocation.IDLocation = tblAsset.LocationFK;
This returns all the assets by their ID (A_Co_Code)
The subfrm also has the criteria below.
Like [Forms]![frmLocation]![subfrmAsset].[Form]![SearchAsset] & "*"

So the results all show in the query (and in the combo box [SearchAsset] but of course the search only opens the subfrm on the correct page if the Location which is in the main form is correct at the time of the search ie the asset i search for is at the location that is open
So prefer A but would go with B
A:It would be good to goto the Form and subfrm as selected
Br do not show other locations assets in the query
Thanks

[libraccess]

So B: I looked at the row source query again and realised I had not referenced [Location] correctly

[Forms]![frmlocation]![Location] so this works
but if anyone can think of a way to search all Forms subforms that would be nice