Form rec value to Report

Topic

New Reply

Code:

How do you pass the current record ID of a record from a form to a report?  
I can launch the report but the ID value is not correct.  
Note:  The report's data source is linked to the same table as the form.

Reply | Quote

Replies

Dave,

there are many possible solutions. Probably the simplest is to pass the ID as part of a Where parameter. If you look at the options for Docmd.OpenReport, you will see one is a WhereCondition. Fill this with a string such as “[ID]=29”, and it should work.

Regards,

Jules

Reply | Quote

Alright, thats working. It turns out I had reset the query and report datasource.
Now, how do I pass the value of the current record (on the form) to that ID value?

ahhh….”ID = ” + Str(MyID)

Thanks Jules!!

Reply | Quote