Run a report from a form based on the current record

[julie67]

How do I run a report, for example to show the attendees for a particular event that I have selected in the form? I want to add a parameter query to select that particular event and run the report based on that parameter all in one shot.

any suggestions?

thanks,
Julie

 

[RoyVidar]

Here's the usual approach Print only the current record to a report

Roy-Vidar

 

[julie67]

I need a little more guidance. Should I build the report off of the original query and not put in a parameter requirement? Where on the command button do I insert this code? I also do not understand this code.

It is important to use the current record since the user could type in the event description incorrectly and would not get any results in the report.

thanks,
Julie

 

[julie67]

I added the code in the event procedure for the command button, but it is not working....obviously I'm not much of a VBA programmer...any help would be great...thanks,julie

 

[julie67]

I think I figured it out...I forgot to add the strWhere in the part of the code:

DoCmd.OpenReport strDocName, acPreview, , strWhere

It seems to be working...thanks for the help

Jules

 

[RoyVidar]

This faq faq181-2886 on how to get the most out of the membership, tells a little about what is often needed to be of assistance (#14) - current code, where is it placed, what errormessage if any, what are the control and field names involved... "but it is not working" doesn't give much to work ong\.

Roy-Vidar

 

[julie67]

Thanks for the tip, however I figured it out by reading the link to the code you provided.