Displaying record number

RyLane

Registered User.
Local time
Today, 13:54
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
 
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"
 
Try this and of course adjust to your PK

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

HTH
 
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!
 
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

Back
Top Bottom