unbound textboxes not filling in.

[ricm9]

I have a function that fills three textboxes when I run my report. The fuction is used as the data source of the third box. This is because one of the arguments is supplied by another textbox's value in the grouping.

Now here's the problem. On the first line the function is called, for some reason the box that contains the function is filled, but not the other two. The remaining lines of the report (however many) operate fine. Now if I click the design (view) report button, and click the run (view) button then the report behaves normally, and all boxes are filled in.

What is going on with the first run that doesn't happen any other time? Why aren't all of the boxes filled all of the time?

 

[ricm9]

Further, I'm finding that the function is actually picking up one of the values from the previous line's textbox.

This is getting crazier.