display record 2 of 6 ie

[stargate]

I have two unbound fields on a form that I would like to display the result in the following way, similar to the record navigation at the bottom of a form.


------- of -------

Field names txtOf = ? txttotal = Count(*)


Any help on how to do this would be appreciated.

 

[ansentry]

Put this in the OnCurrent Event of your form.

If Me.NewRecord Then
        Me.txtResult = "New Record (" & Me.RecordsetClone.RecordCount & " existing records)"
    Else
       Me.txtResult = "Record " & [CurrentRecord] & " of " & Me.RecordsetClone.RecordCount
    End If

Put an unbound text box on your form and name it txtResult.

This should do what you want.

 

[ghudson]

If Me.NewRecord Then
        Me.txtResult = "New Record (" & Me.RecordsetClone.RecordCount & " existing records)"
    Else
       Me.txtResult = "Record " & [CurrentRecord] & " of " & Me.RecordsetClone.RecordCount
    End If

That code looks familiar. Record X of Y

 

[stargate]

sorry for the late reply..been on a training course.

It works nicely.

Many many many thanks! much appreciate. I know you are busy replying to many other posts.