How to change the form title or caption from VBA.

[PuddinPie]

Hello,

I'm trying to create a module that when a form opens it will look at the module and set the forms title as per what it says in the module.
I've been looking arround but can't seem to find a specific way of doing it.

Does anyone know how this would be done?

Thank you.

 

[MarkK]

You'd set the Access.Form.Caption property.
If you have a public property in a module, something like ...

Public Property Get HelloWorld as String
  HelloWorld = "Hello World!"
End Property

...then, in the open event handler of a form you could do...

Private Sub Form_Open(Cancel as Integer)
  Me.Caption = HelloWorld
End Sub

Does that help?