subform problems

[Matt Brown]

How do i search a subform?

I have a form that has a query as the record source.

On this form is a subform.

I can search the main form without any problems through the forms query.

When i add the subform's table to the query row source seems to throw up parameter boxes.

The relationship between the main form and the subform is 1 - many.

Any help on this much appreciated.

Thanks

Matt

 

[quasimodo]

try having the query search from the subform form, and not the subform on the main form...

 

[Matt Brown]

Duh

I didn't have my sql syntax quite right, it is now working.

Thanks for your reply quasimodo

Think it was getting late in the day for me, brain not in gear...