Setting the input query of a report programmatically

  • Thread starter George Papadopoulos
  • Start date
G

George Papadopoulos

Hello everybody

I have created a report and binded it to a form. The report takes it`s
dynaset from a static query that I`ve created. I now wish to have the report
called from within a form. The report should print a dynaset based on fields
on a form. (e.t.c. for a specfic date interval only).
Thus, I need to change the dynaset query of my report dynamically, using
VBA. Does a report object have a property or method that helps me do that?

thx, in advance

George Papadopoulos
 
G

George Papadopoulos

Hello everybody

I have created a report and binded it to a query. The report takes it`s
dynaset from a static query that I`ve created. I now wish to have the report
called from within a form. The report should print a dynaset based on fields
on the form. (e.t.c. for a specfic date interval only).
Thus, I need to change the dynaset query of my report dynamically, using
VBA. Does a report object have a property or method that helps me do that?

thx, in advance

George Papadopoulos
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Report Input Parameters 2
Null recordset problem 6
Report Combo Box 1
PLEASE HELP: Refresh columns displayed in a report from a query ou 5
Summary Report 2
Printing Report from input Form 4
Setting recordsource property of report 2
Form for inputing criteria for a report's query 1

Top