Displaying record number (1 Viewer)

RyLane

Registered User.
Local time
Today, 13:46
Joined
Feb 4, 2014
Messages
60
Hi,

Wondering how to make a text box on a form display the record number so it can be seen along side record selector buttons.

I'd rather have my own then use the record selector option that displays at the bottom of the form when enabled.

Thanks,

Ryan
 

RyLane

Registered User.
Local time
Today, 13:46
Joined
Feb 4, 2014
Messages
60
Yeah, that's all I'm trying to do. The code for the current record number works but the code for the number of records keeps returning Name? errors. Might be because RecordsetClone and record count are not in the list of Expression Values. Any ideas? It'd be nice to put "1 of X" on the form instead of just "1"
 

burrina

Registered User.
Local time
Today, 12:46
Joined
May 10, 2014
Messages
974
Try this and of course adjust to your PK

="Record Count is" & " " & Count([CustomerID])
HTH
 

RyLane

Registered User.
Local time
Today, 13:46
Joined
Feb 4, 2014
Messages
60
Got it working the way I want with a combination of your two answers

=[Form].[CurrentRecord] & " of " & Count([TrainingUser])

This gives me what I wanted "1 of 10"

Thanks!
 

burrina

Registered User.
Local time
Today, 12:46
Joined
May 10, 2014
Messages
974
Glad you got it worked out, we were both glad to try and help!

Good Luck With Your Project!
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom