Handling query criterias from dif forms

[capsula4]

Hi!

I have two forms, formA and formB.

Then i have a query called queryX.

I have a report called reportX.

I would like the query/report to show only a determined entry by the ID of that record, not all the records.

So i have in formA and formB "Show Report" button, but when I click the button, it shows all the records in the database, not the one being shown in a form.

Ok, I guess I have add a criteria in queryX, but I have to make it refering to a field of formA and formB.

Is there a way to handle a criteria from dif forms or do I have to make one query and one report for each form? The big deal is when I gotta modify something in a report, I will have to make in all of em.

 

[pbaldy]

I would have one query/report that returns all records. When you call the report, use the wherecondition argument of OpenReport to restrict the records. More info in Help.

 

[capsula4]

Thank you! I could make it work really great in that way.