Form caption (1 Viewer)

[rhay]

Is there a way in the Form Caption when open it will display the name ( a field in the form)of the current record being viewed?

Thanks,

Robert

 

[Jack Cowley]

In the On Current event of the form:

If Me.NewRecord Then
Me.Caption = "New Record"
Else
Me.Caption = Me.FieldWithDataYouWantToDisplay
End if

 

[rhay]

Thanks Jack,

It worked great!

Robert