Referencing Objects in Form Header/Footer?

[thadius856]

This should be a pretty darn easy thing to do, but I'm stumped and searches are coming up blank. How do I reference an object in my form's header/footer?

I'm simply trying to set a label caption in Form_Load(), but the object name never shows up in the autocomplete and I get compile errors when it runs. I moved the object from the header into the body of the form and the script works fine, but then aesthetics suffer.



I've tried all sorts of weird stuff, like:

Me.FormHeader.MyObjectName.Caption = ...
Me.Section(1).MyObjectName.Caption = ...
Me.Section(ac_formheader).MyObjectName.Caption = ...
etc etc ad naseum

I'm sure it's right in front of my face, but I just can't see it. :|

[June7]

This works for me:

Me.Label64.Caption = "NEW"

[thadius856]

This works for me:

Me.Label64.Caption = "NEW"

That was the first thing I tried. I use it on just about all of my forms with no issue, but for some reason when the object is in the header it's not playing nice.

[thadius856]

Looks like when I swapped over to my new login splash screen, I forgot to also move the line that inits my globals on load.

So when I was loading the form, the SQL statement that uses that global as its WHERE condition was returning no results instead of the UserID from the users table.

It wasn't that the label didn't exist... it was that the global didn't. :| The generic "no object exists" error was throwing me off.

Closing. Sorry for the false alarm.