Caption Modal with field

[mpaulbattle]

Is it possible to caption a Modal form with a field from the tables?

For example, when they click to open the form they enter which practice they're looking for (mnemonic) and it will pull the information for that specific practice. I would like the mnemonic to appear where the caption of the form goes.

 

[Minty]

You can set a forms caption in vba on form load, or any other event you care to choose.

Me.Form.Caption = "Practice " &  Nz(Me.YourFieldName,"")

 

[mpaulbattle]

Thanks Minty. That works.

 

[Gasman]

Use OpenArgs?

Private Sub Form_Load()
If Nz(Me.OpenArgs, "") <> "" Then
    Me.Caption = Me.OpenArgs
End If

End Sub

HTH