How can I use info from the current record to put into a report?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to take a current record with all its information and put it into
an existing report that I have designed myself. I've tried creating a button
(going through the wizard) and making it open the report which works, but it
does not open the correct record.

For example, I'm at record 23 and need a report printed off for it. I click
the button for the custom report and it starts back at record 1. Is there a
way to tell it to open record 23?
 
OK I can see the code on that website and it does make sense. However, I'm
not quite sure what he means by a RunID control. What do I have to do to
modify that code to make it work for me? I know very little about coding with
MS Access but I have some experience with VB.
 
You would first create the code using the Report Preview command button
wizard. Then modify the code to match the website code. You would need to
replace the RunID with references to the primary key field in your table.

You haven't provided any information about your table structure or fields
and datatypes so we can't be of much more assistance.
 
Back
Top