I have a report that was generated from parameter query.
I want to put a command button on my form, when I need to print current record and related child records, just click on that button to view the report preview.
But now, when I press this button "Enter Parameter value" dialog box was always appear. I dont want to re-type the DNo, that was already appear on the form.
But I don't know how to pass that data with VB code.
My SQL query code is .....
SELECT tblRR.*, tblMD.*, [DNum] AS Exp1
FROM tblMD RIGHT JOIN tblRR ON tblMD.DNo = tblRR.DNo