I have 2 issues with printing a report. I know this has been asked before but i dont seem to be able to get the results i re quire from them.
I currently have a button set up on a form to preview a report. When clicked it runs a query which askes me to place the Auto id no in. it then filters the form to this ID. How do i get it to automactically place the ID number in so the user doesnt have to entre it.
The second problem is when you look at the above query it lists several enteries for the same ID no. This seems to be dictaded by the sub report and the amount of records in there. I.E. 4 records printed records.
any help would be great.
cheers
EQ
I currently have a button set up on a form to preview a report. When clicked it runs a query which askes me to place the Auto id no in. it then filters the form to this ID. How do i get it to automactically place the ID number in so the user doesnt have to entre it.
The second problem is when you look at the above query it lists several enteries for the same ID no. This seems to be dictaded by the sub report and the amount of records in there. I.E. 4 records printed records.
any help would be great.
cheers
EQ