Searching a subform.

[JVermast]

Is there any way to have a query box on one form and have it "filter' persay a list of entries in a form/query in a subform below?

I can't seem to get it to work or find any help on the subject.

 

[ScottGem]

Is there any way to have a query box on one form and have it "filter' persay a list of entries in a form/query in a subform below?

I can't seem to get it to work or find any help on the subject.

If I understand you, you want to filter a combo or list box on a subform based on a value in a cotrol on the mainform. If so, then in the query behind your combo/list set the criteria for the relevent column to:

=Forms!mainformname!controlname

You should also do a Requery of the combo/kist. I would do it in the Gotfocus event:

Me!controlname.Requery.

 

[JVermast]

If I understand you, you want to filter a combo or list box on a subform based on a value in a cotrol on the mainform. If so, then in the query behind your combo/list set the criteria for the relevent column to:

=Forms!mainformname!controlname

You should also do a Requery of the combo/kist. I would do it in the Gotfocus event:

Me!controlname.Requery.

I have a search box and a submit button. Below that in a sub form I have a form that lists all of the entries associated with a certain project #. So I want it to be like this


|____1_____| Search

________Subform_____
1. Josh Vermast
1. Dave Thomas
1. Bob Price
____________________

 

[ScottGem]

If you are trying to filter the subform with a selection on the main form then you should be linking the 2.