macro or code?

C

Casey

SF,

What you can do is in the query, instead of just using
the persons name, put [Please enter name]. Then whenever
the report prints out it will ask Please enter name,
giving you the flexibility of a choice of entry. Also,
you could place a combo box on a form, using as a source a
table containing all of the names you are interested in.
Then set in the query of the report

[forms].[formname].[comboboxname]

But use the real name of your form instead of
formname, and real name of your combo box instead of
comboboxname.

Either of those alternatives will work.

Also, you can place a button on a form, and in
the "onclick" property of that button, assign/create a
macro which uses the "openreport" action to open your
report.

Casey
 

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

Top