Select line from a form for a report

[drf3794]

Hello, I currently have a form that shows each customer and the workorders on a subform that are entered for that customer and another subform that shows each item from the workorder that is highlited on the above subform. My problem is I would like my command button to select the workorder line that is highlited from the subform and display that information on my report. I can get the button to display the report, but with all of the data in the workorder table not just the line item in the subform. Any help would be appreciated.

Sincerely,


David

[haquocquan]

Hello, I currently have a form that shows each customer and the workorders on a subform that are entered for that customer and another subform that shows each item from the workorder that is highlited on the above subform. My problem is I would like my command button to select the workorder line that is highlited from the subform and display that information on my report. I can get the button to display the report, but with all of the data in the workorder table not just the line item in the subform. Any help would be appreciated.

Sincerely,
David

When you select item (record) in subform, the textbox will get value of that record. You can filter by this value.

[drf3794]

Hello, Thankmyou for the post. Do you know what the "where clause" for the button would be? Or how do I find what the value of the line in the subform is? There are anywhere from 1 to 20 lines showing in the subform at any time. I need the value from the line that is selected in my subform. Thanks for the help.

David

[haquocquan]

For example:
Your source for subform includes fields: ID(text), IDNAME, ....
And textbox in subform named: ID(text), IDNAME,....
And source for report is the same as subform.
command button code:

docmd.openreport "reportname", acpreview,,"[ID]='"& forms!mainform!subform!ID &"'"

---------------------------
Sorry for not clear. My English is not good.