VBA output to report

A

AJ

I have a VBA procedure that I run after a user inputs some information into a
form. Can I output the calculations from the VBA procedure to a report and
maybe include some information from a table?
Example:

Input(form) --->> VBA procedure (Calculate fields) --->output to report

I guess what I am trying to find out is can you assign a value to a field on
a report in a similar way you do to a form?
[Forms]![NameOfYourForm]![NameOfTheControl]
 
T

Tom van Stiphout

On Thu, 24 Jan 2008 20:14:01 -0800, AJ <[email protected]>
wrote:

Take 1 minute to try it.
You'll find yes, if you preceed the expression with an "=" sign.
You can also call public functions:
=SomeFunction()

-Tom.
 
Ð

ДениÑ

AJ said:
I have a VBA procedure that I run after a user inputs some information into
a
form. Can I output the calculations from the VBA procedure to a report and
maybe include some information from a table?
Example:

Input(form) --->> VBA procedure (Calculate fields) --->output to report

I guess what I am trying to find out is can you assign a value to a field
on
a report in a similar way you do to a form?
[Forms]![NameOfYourForm]![NameOfTheControl]
Click to expand...
 

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

export VBA code in forms, modules and reports 3
How to pass a value from a from to a Email sending VBA module 2
Report output appears to be in Chinese 1
Access Access Report Works on One Machine but not Another 3
Run select query from VBA code where criteria comes from a multi select ListBox 2
Form and Report Calculations slow 1
Transfer data from form to report - Please Help!! 9
Access 2007: How to run reports from forms??? 2

Top