Displaying record number (1 Viewer)

[RyLane]

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]

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]

Try this and of course adjust to your PK

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

HTH

 

[RyLane]

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]

Glad you got it worked out, we were both glad to try and help!

Good Luck With Your Project!