priority on fields in a report?

[Atomsk]

Is there any way to make it so that certain objects, such as text boxes, load before everything else in a report? In my case, I have a text box that prompts an input box and returns a set of values, which the rest of the data in the report depends on. The problem is, sometimes this text box loads first; other times, it loads after everything else, which breaks all of the relationships. Does anyone know whether this is possible? Thanks a lot.

 

[dhookom]

Can you try to place the prompt in the query? Just create a field like:
MyValue:[Enter My Value]
Then, you can use MyValue like any other field in your query. A better solution might be to enter the value in a text box on a form.

Duane
MS Access MVP