Textbox value only on first page of report

[LaurelLee]

I have an insignificant although elusive problem. Yesterday, I had to inmport all of my objects into a new db as the previous db became corrupted. All is well, except one tiny problem. One control on my report that resides within the page header displays a value the user chooses from a form. This displays just like it should on the first page, but on subsequent pages displays only "#ERROR". My text box contains
="HULL " & Forms!frmSort1!cbxHull

I have tried to use code to fix the problem, namely by including
txtHullNo = FORMS!frmSort1!cbxHull
within the PageFooterSection_Format procedure. This errors, saying it is unable to find my form.

Does anyone see the resolution? I sure can't!

Thanks!!



___________________________________________________________
With your thoughts you create the world--Shakyamuni Buddha

 

[luceze]

Does your form remain open during the print process?

 

[LaurelLee]

<smack palm on forehead>
DUH! I am ready for this day to be over. Thanks for pointing out the ever-elusive obvious!!!!



___________________________________________________________
With your thoughts you create the world--Shakyamuni Buddha

 

[luceze]