turning the value of a field into the title of a form

[boglevee]

Hi all,

When I'm cycling through separate records, I want to see the title of the form change depending on the record. Specifically, I want two field values to show up.

i.e. if there is a field "Name" and a field "Age", when I cycle through different records in form view, i want the title of the form window to be "James 23" for one record, and "Jane 56" for another.

Can this be done? I'm familiar with going to properties/format/caption for the form name, and wondered if there is a command that can be entered there.

Thanks!

[ADezii]

Hi all,

When I'm cycling through separate records, I want to see the title of the form change depending on the record. Specifically, I want two field values to show up.

i.e. if there is a field "Name" and a field "Age", when I cycle through different records in form view, i want the title of the form window to be "James 23" for one record, and "Jane 56" for another.

Can this be done? I'm familiar with going to properties/format/caption for the form name, and wondered if there is a command that can be entered there.

Thanks!

It can be done very easily, in the Current() Event of your Form, place the following code:

Private Sub Form_Current()
'Only display Name and Age in the Form Caption if both values are present
If Not IsNull(Me![Name]) And Not IsNull(Me![Age]) Then
  Me.Caption = Me![Name] & " " & Me![Age]
Else
  Me.Caption = "Some Generic Caption"
End If
End Sub

[missinglinq]

Private Sub Form_Current()
    Me.Caption = "Record for:   " & NameField & "  Age:  " &  AgeField
End Sub

[missinglinq]

We gotta stop stumbling over each other like this, ADezii!

Linq ;0)>

[ADezii]

We gotta stop stumbling over each other like this, ADezii!

Linq ;0)>

Great minds think alike!

[boglevee]

Um, you guys are totally my heroes right now.

[imrosie]

Um, you guys are totally my heroes right now.

Wow, my heroes too.

I was just about to ask a queston on this in the Access Forum and stumbled upon this information. Thanks!

Rosie

[missinglinq]

That's why it really is important to run a search here before posting a question! Those of us here who answer questions on a regular basis do so because we enjoy programming and enjoy teaching others how to program, but it's becomes very tiresome after you've answered the same question for the twentieth time!

Have a great day, Rosie!

Linq ;0)>