unable to assign a vaule to text box in footer of a subreport

[markjkubicki]

I have a simple subreport where I want to assign a value to a text box in its footer, but am getting an error, and unable to assign...
I've tried moving the code in to multiple events (open, load, format, <etc>...) but none of them seem to work ?


in it's simplest form the code is:

Private Sub ReportFooter_Load(Cancel As Integer, FormatCount As Integer)
If something...
Me.txtInstallationNotesAtFooterAbout.Value = "Refer to end of Fixture Schedule for additonal notes about... "


else
Me.txtInstallationNotesAtFooterAbout.Value = "some other message..."
End Sub

in advance, thanks, any thoughts would be greatly appreciated
mark

[pbaldy]

What error? I'd use the format event of that section. What is the control source of the textbox?

[markjkubicki]

the error is
#2448 "can't assign value to this object"

the control souorce for the text box is empty (nothing)

[pbaldy]

Not sure why it's not working then. Can you post the db here, or a representative sample?

[markjkubicki]

later tonight, I'm going to play with it a little more; my hunch is that it's something stupid (like I have a control with the same name on the parent report that is causing a conflict, or "something" else...) If I still can't find the glitch, I'll be back, and either way, I'll let you now

again, many thanks in advance,
mark

[boblarson]

Pardon me for jumping in here but you have shown us:

If something...

which may be very important part here. I've been able to use the code you had successfully even if I refer to a field on the report which ends up the last record is what determines what will show up in the footer. But it is the question of what are you asking.

The other possibility is corruption - if something that should logically work and no other cause can be found it is likely corruption. Try importing (import, not copy and paste) the report into another database shell and reimport it back (making sure that Name AutoCorrect is turned off).

[pbaldy]

Gotcha. I did do a quick test and had no trouble setting an unbound textbox in the report footer's format event.