Asking User for an Input Value

[arm1]

I am hoping someone can help me with an issue I have:

I have a report. It is unbound!

There is a field on it that tries to ask the user for an input value

(for this field, I have set the control source to " =[Please enter an value: ] ")

This report also has 2 different sub-reports within it.

These two sub-reports try to utilize the user value in a calculation.

When I run this report (open it), it shows the value for the input field to be ?NAME?

I realize this means it does not recognize the control source I have put for it.

HOWEVER...

If I simply bind the report to something (a query, for example)... then it DOES recognize the record source for this field, and upon running the report, an inputbox appears asking the user to enter a value.

Why does this only get recognized if the initial report is bound?!?

What changes when the report is UNBOUND that suddenly makes the control source value unrecognizable?

Finally... what can I do to keep my initial form UNBOUND, but still be asking the user for a value that I can get, AND display in a field on this report.

Thank you for any help you may be able to offer,

- arm1

 

[Mr. B]

In the Open event of your report try using the InputBox (much like the msgBox) to get a value from the user and then use the value any way you need to.

 

[boblarson]

Subreports load before the main report, so that could be causing your issue.