order of processing??

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

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" wrote in message
...
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

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.

"Gina Whipp" wrote in message
...
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" wrote in message
...
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

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.

"Gina Whipp" wrote in message
...
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" wrote in message
...
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'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.

--
Duane Hookom
Microsoft Access MVP


"Laurel" wrote:

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.

"Gina Whipp" wrote in message
...
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" wrote in message
...
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

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?

"Duane Hookom" wrote in message
...
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.

--
Duane Hookom
Microsoft Access MVP


"Laurel" wrote:

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.

"Gina Whipp" wrote in message
...
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" wrote in message
...
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

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" wrote in message
...
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?

"Duane Hookom" wrote in message
...
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.

--
Duane Hookom
Microsoft Access MVP


"Laurel" wrote:

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.

"Gina Whipp" wrote in message
...
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" wrote in message
...
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

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.

"Gina Whipp" wrote in message
...
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" wrote in message
...
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?

"Duane Hookom" wrote in message
...
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.

--
Duane Hookom
Microsoft Access MVP


"Laurel" wrote:

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.

"Gina Whipp" wrote in message
...
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" wrote in message
...
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