The problem is that on activate event it does not allow to allocate the
recordsource
"Allen Browne" wrote in message
...
Use your query as the RecordSource of the report.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Vivek Sharma" wrote in message
...
I have my report generated on Acticvate event. My query is fetching
multiple results but it allocates only the last result to the text
fields. How can I repeat the detail section and show all the records?
Thanks
Vivek