Change Form Caption When Moving From Records (Access 2k)

[deekatz]

How can i accomplish this...
As I move from one client's record to another I want the form caption (frmClientInfo) to display the form name and in parenthesis the client's first and last name. FOr e.g. if I am working on John Smith's record, I would like for the form caption to say Client Info (John Smith) and as I move to Tory Smith's record, the caption will say Client Info (Tory Smith)

[NYIntensity]

For your form's On Current event, use this

Me.Caption = "Client Info " & [ClientFirstName] & " " & [ClientLastName]


etc...

[gdrezek]

I keep a hidden textbox on the form whose control source has the value I want to display. (you can also use DLookup as well)
TheniIn the OnCurrent event of the form:

Dim strCaption As String
strCaption = "Client Info '" & Me!txtTextBoxName & "'"
Me.Form.Caption = strCaption

gdr