How to put a message in record navigation bar at bottom of form

[PMrider]

I have a form with a subform and a subform in the first subform. I have 3 record navigation bars showing at the bottom of my form and I would like to put a message in each bar so user can determine which bar is for what. Does this make sense?

Also if I disable the record navigation bars, is there a way to to show "record x of y" anywhere else in the form?

any help would be appreciated

Alan

 

[HWMoser]

I like to put a text box at the bottom of my forms. Control source should read something like this:

="Record " & [CurrentRecord] & " of " & Count([FieldName]) & " Records"

You can also use the caption property to do the same thing in the forms caption:

Public Function Cap()
' sets the caption for the form
Dim X As Integer
If Me.NewRecord Then
Me.Caption = "Text you want to show its a new record"
Else
X = DCount(FieldName, "table or query name&quot
Me.Caption = "Record " & CurrentRecord & " of " & X
End If
End Function

Then call the function from the forms On Current event.

Hope this helps.

HMoser