order of processing??

[Laurel]

I have a report that has two text boxes containing calls to user functions
(written by me). My problem is that the first function (speaking top to
bottom in the report layout), does some processing that the second function
uses, but the report is processing the second function before the first one.
I did create the second text box before creating the first one and then
completed the underlying code. The result is that the output of the second
function shows data from the row above it. Can I control the order in which
the text boxes and their functions are processed?

TIA
LAS

 

[Gina Whipp]

Laurel,

Without seeing the code I would say look up DoEvents in Help. It will
assist in pausing function 2 till function 1 has finished.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Laurel]

Thanks. But I can tell that the function in one is actually executing
before the function in 2. I call them 1 and 2 because of their position,
vertically, on the page. I can tell because I put debug breaks at the
beginning of the functions called by the text boxes. The numbers are
apparently reversed in Access's mind.

 

[Laurel]

I should have mentioned that I got in this fix because I wanted to break one
big function, that wrote to temp tables, and then subsequently formed
strings from that data, into two separate functions. Originally it was
address and dependents. But I wanted them to be separate, and the address
function was gathering data for the dependents' function. I will create
redundant loops if I need to.

 

[Duane Hookom]

Gina's statement "Without seeing the code" was a hint that if you really want
some assistance, you might want to either post your code or tell us
everything it does and why. When you try something that is unorthodox, you
need to provide a good description so readers can understand.

 

[Laurel]

The code is irrelevant. The question is simple. Is there a way to control
the order in which controls on a report are actually activated?

 

[Gina Whipp]

Laurel,

The code is not irrelevant as there is ALWAYS a way to control it and not
always a way to control the report. Please post the code OR not but if not
we are limited as to what we can do (at least I am).

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Laurel]

Thanks. I've solved the problem, as I mentioned above. So I really didn't
need a solution to the problem. Just an answer to a question that might
have given me a quicker solution or just have satisfied my curiosity.
Thanks for your willingness to dive in on the whole problem, though.