Having a report on one specific record

[t3nchi]

I have a form with a subform. The mainform has 3 combo boxes in which I select the right choices to pull up the right record in the subform. I want to generate a report for that record only.

As of now, what I did was use a 'open record' macro. But this preview-prints all the records instead of that ONE record in the subform only.

How do I do that? Thanks.

 

[t3nchi]

anyone? I would think this would be simple for the more experienced folks here...I'm a noob.

 

[Smart]

I would create a query that uses the values from your combo boxes to select the details you require (same as the details on the subform) then creat a report based on the query. create a button on the form and in the on click event call the report

 

[t3nchi]

Cool,that helped,thanks.