That is what I need but now when I ru nthe report, as I already have a prompt
box in the query (asking for letterID numbers), the message box is merging
the two together.

Originally it prompted the user to [Enter Letter ID (seperate multiple
records by a comma, no spaces:]

Then I added in a text box in the actual report =[Enter Decision Date]

But when I run the report, the box now indicates:

[Enter Letter ID (seperate multiple records by a comma, no spaces: ], 1
[Unknown] = [Enter the Decision Date]

and the report fails to to anything.

Is there any code to allow more than 1 prompt?

"ghetto_banjo" wrote:

Well, if you ever need to know a decision date of a past letter, then
you really should store it in the table. Otherwise, it will only be on
the printed letter.

If that is not an issue for you, you can make the report prompt for it
via a text box.

Just set a text box to:

[Enter Decision Date]


And that will prompt every time you open the report.
.