Main form searched/filtered by subform

[jk12]

Hi all, hopefully someone will be able to give me a straight answer to this one even if its as simple as yes or no, however if its yes I hope you could explain how.

My question is:
Is there a way to have a subform filter or go to a corresponding record in the main form. Subform is linked to main form by w/c but both have a person name field in them. The subform is a continuous form so what I've been asked to do is allow users to find a record in the subform which will the show other information linked to this in the main form.

Hope this makes sense, it seems a bit backwards to me but this is what I've been asked to do so it's what I'll try and deliver.

Thanks

 

[Dennisk]

if you want to use the subform for searching only then this is not the way to go. Use a form for you searching, or instead of a subform create a combo box instead or even better use the combo box wizard to 'find a record'

 

[jk12]

I agree with you and like I said what I've been asked to do does seem backwards. I'm not one to argue and try to give what the user wants so again although I agree with your method, if you know a way to filter/search/find a record in the main form based on criteria in the subform, any suggestions would be taken.

 

[Dennisk]

You could set a filter for the main form from the sub form. Or, you could change the record source of the main form to a query that uses the current value from the subform as criteria.

 

[Rich]

Why would the persons name be in two tables?