Is there a way to automatically generate the text in the form caption at the top of the form (Where the min,max buttons are)based on particular data ?
ie: I have a form that is able to look up orders for a client and then display them on a seperate form. When this form is generated I would like the caption to read "Orders for Bill Smith" or who ever.

This is what I have, placed on the on current of the form.

Ian


Private Sub Form_Current()
If Me.NewRecord Then
Me.Caption = " NEW RECORD BEING ENTERED "
Else
Me.Caption = " " & Me.Title & " " & Me.First_Name & " " & Me.Surname & " "
End If
End Sub