how do i display the current record im viewing ona form?

[smoke]

thanks ................

 

[WayneRyan]

smoke,

You are always displaying the current record on your form.

Do you mean choose from a listbox or combobox, then view?

Do you mean print a report for the current record?

Wayne

 

[smoke]

no i removed the control stuff and made my own on my form but i need to display the current record im on, because it doesnt display it cuz i removed the status bar thing.

 

[ghudson]

Are you referring to the Record X of Y info? If so, try this in your forms OnCurrent event...

Private Sub Form_Current()

    If Me.NewRecord Then
        Me.Form.Caption = "Your Form Name - New Record (" & Me.RecordsetClone.RecordCount & " existing records)"
    Else
        Me.Form.Caption = "Your Form Name - Record " & [CurrentRecord] & " of " & Me.RecordsetClone.RecordCount
    End If

End Sub