Setting the input query of a report programmatically

  • Thread starter Thread starter George Papadopoulos
  • Start date 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
 
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
 
Back
Top