runsql to propogate value in report textbox?

[David_Beginner via AccessMonster.com]

Is it possible to create a select query in vba in order to propogate a value
in a text box in a report?

 

[fredg]

Is it possible to create a select query in vba in order to propogate a value
in a text box in a report?

I have no idea what you mean by "propagate a value in a text box in a
report?"

But, regardless, you cannot run a select query using RunSQL.
RunSQL can only be used to run an Action Query, i.e. Append, Update,
Delete, etc.

Now if you care to post back with more detail as to what it is you are
trying to accomplish, perhaps some one can help.

 

[David_Beginner via AccessMonster.com]

Populate.

Thank you for the answer.
I am trying to create a somewhat complex billing statement.
I posted it under reports "billing statement" in more detail.
I thought populating multiple text fields on a report using multiple queries
through vba could solve my problem efficiently.
Thank you for your reply.

david