Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 06-05-2014, 08:17 AM   #1
RyLane
Newly Registered User
 
Join Date: Feb 2014
Posts: 60
Thanks: 14
Thanked 0 Times in 0 Posts
RyLane is on a distinguished road
Displaying record number

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 is offline   Reply With Quote
Old 06-05-2014, 10:12 AM   #2
RyLane
Newly Registered User
 
Join Date: Feb 2014
Posts: 60
Thanks: 14
Thanked 0 Times in 0 Posts
RyLane is on a distinguished road
Re: Displaying record number

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"
RyLane is offline   Reply With Quote
Old 06-05-2014, 10:26 AM   #3
burrina
Newly Registered User
 
Join Date: May 2014
Posts: 974
Thanks: 67
Thanked 151 Times in 133 Posts
burrina will become famous soon enough
Re: Displaying record number

Try this and of course adjust to your PK

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

burrina is offline   Reply With Quote
The Following User Says Thank You to burrina For This Useful Post:
RyLane (06-05-2014)
Old 06-05-2014, 11:34 AM   #4
RyLane
Newly Registered User
 
Join Date: Feb 2014
Posts: 60
Thanks: 14
Thanked 0 Times in 0 Posts
RyLane is on a distinguished road
Re: Displaying record number

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!
RyLane is offline   Reply With Quote
Old 06-05-2014, 11:53 AM   #5
burrina
Newly Registered User
 
Join Date: May 2014
Posts: 974
Thanks: 67
Thanked 151 Times in 133 Posts
burrina will become famous soon enough
Re: Displaying record number

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

Good Luck With Your Project!

burrina is offline   Reply With Quote
Reply

Tags
count , display , forms , record

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] how do i go from one form to another with the same record number displaying? cjl Forms 4 01-23-2019 02:33 AM
Split Form's Navigation Buttons Not Displaying Record Number or Number of Records JamesJoey Forms 9 10-16-2012 02:42 AM
Auto number not displaying number paulcraigdainty Forms 6 05-26-2009 03:44 AM
Displaying current record number on a form Chris South Forms 2 03-10-2004 11:18 AM
Displaying information associated with an ID number Nova_C Reports 2 04-26-2002 07:58 AM




All times are GMT -8. The time now is 08:18 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World