Record X of Y

[Nad]

Hi Guys,
How do i display record X of Y on my from(in TextBox).My form is based on
Updatable query & i removed the record selector.
Help Please...
Thanks & Regards,

 

[Allen Browne]

Try:
=[Form].[CurrentRecord] & " of " & [Form].[RecordsetClone].[RecordCount]

There are some problems with that:
a) When you first load the form, the RecordCount may be 1. So it may not
give the correct count until it finishes loading records.

b) Access 2007 will fail with that expression. You will need to use a
function to get the count in this version.

c) Really old versions (Access 2 and earlier) can't handle this either.

More info:
Numbering Entries in a Report or Form
at:
http://allenbrowne.com/casu-10.html

 

[Nad]

Thanks Allen for your quick reply.
I did like this and its working fine.

Private Sub Form_Current()
Dim RecCount As Integer
RecCount = Me.RecordsetClone.RecordCount
Me.TxtRecCount = Me.CurrentRecord & " of " & RecCount
End Sub

Regards

Try:
=[Form].[CurrentRecord] & " of " & [Form].[RecordsetClone].[RecordCount]

There are some problems with that:
a) When you first load the form, the RecordCount may be 1. So it may not
give the correct count until it finishes loading records.

b) Access 2007 will fail with that expression. You will need to use a
function to get the count in this version.

c) Really old versions (Access 2 and earlier) can't handle this either.

More info:
Numbering Entries in a Report or Form
at:
http://allenbrowne.com/casu-10.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Hi Guys,
How do i display record X of Y on my from(in TextBox).My form is based on
Updatable query & i removed the record selector.
Help Please...
Thanks & Regards,