Macro to create an address in report

[Abby]

Is it possible to have a user type text in a text box and
have a macro run based on what is entered in that text
box? Example: If my user types in RRP in a particular
text box, can I run a macro that changes RRP to an address
for RRP that will display when my report is generated?
Thank you.
-Abby

 

[Steve Schapel]

Abby,

THis is not a job for a macro. If I understand you correctly, you will
need a table where the text codes and their associated addresses are
stored, so for example RRP and the address for RRP will be in a record
in this table. Then, the query that your report is based on will need
to include this table, joined to your main table on the text code field,
and then you will have the Address available to you to include in the
report.