Selecting value on subform

[Eleventy]

So I have a customer search form where the user enters parameters and it brings up a tabular subform that is requeried based on the search parameters.

Basically I am looking for a way for the user to select the record they want based on the search parameters and then bring up all the jobs/products that particular customer has ordered.

That is to say, it would bring up another search form and you could further narrow down the values.

Any ideas?

 

[MajP]

look at Docmd.openform

http://www.ozgrid.com/forum/showthread.php?t=56692&page=1

The fourth argument is a where statement.

something like
"customerID = " & me.customerID