Opening a specific instance of a report from a form

[kejo41]

I have made a report that will print out information on over 5000 clients. I
also have a form where I can edit data on each client. I want to be able to
open only the report corresponding to the client that is currerntly being
edited in the form without having to type in the clients ID each time. I
tried using OpenArgs but it doesn't seem to work in a report like it does in
a form, Filtering has not worked for me either. I would sure appreciate some
help.

 

[Marshall Barton]

I have made a report that will print out information on over 5000 clients. I
also have a form where I can edit data on each client. I want to be able to
open only the report corresponding to the client that is currerntly being
edited in the form without having to type in the clients ID each time. I
tried using OpenArgs but it doesn't seem to work in a report like it does in
a form, Filtering has not worked for me either. I would sure appreciate some
help.

Use the OpenReport method's WhereCondition argument in a
command button's event procedure. I think there's a button
wizard that will generate most if not all of the needed
code.

 

[Allen Browne]

Here's an example of the code Marsh is talking about
Print the record in the form
at:
http://allenbrowne.com/casu-15.html

Make sure the report is not already open - not even in design view.

 

[kejo41]

Thank you both so much it worked like a charm.