By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,973 Members | 1,854 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,973 IT Pros & Developers. It's quick & easy.

How to Show AutoNumber Value in Form

P: n/a
I have a simple complaint tracking Db with one main table and one main
form for entering data. I need for the users to be able to see the
record number for future reference when they come back to the
application to update or close that record. The record number is field
RecordId and is an AutoNumber field. (Also the primary key) Is there a
way to show the AutoNumber value in the form when a new record is
opened?

Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
DHRRush wrote:
I have a simple complaint tracking Db with one main table and one main
form for entering data. I need for the users to be able to see the
record number for future reference when they come back to the
application to update or close that record. The record number is field
RecordId and is an AutoNumber field. (Also the primary key) Is there a
way to show the AutoNumber value in the form when a new record is
opened?


As soon as the user dirties the record (begins typing) then the ID number
will become visible. The database doesn't know what the next number will be
until that happens.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #2

P: n/a
DHRRush wrote:
I have a simple complaint tracking Db with one main table and one main
form for entering data. I need for the users to be able to see the
record number for future reference when they come back to the
application to update or close that record. The record number is field
RecordId and is an AutoNumber field. (Also the primary key) Is there a
way to show the AutoNumber value in the form when a new record is
opened?


Just create a text box w/ the Autonumber column as its ControlSource
property. You might want to disable and lock the text box so the users
won't be tempted to mess about w/ it; though they would only get an
error message saying they can't change it, its best to avoid all that by
just not allowing them to fiddle w/ it.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
Nov 13 '05 #3

P: n/a
You're right, I din't realize it because the second field was a date
set to autofill with the current date. Once I got to playing with the
records, it behaved as you described.

Thanks.

Nov 13 '05 #4

P: n/a
You're right, I din't realize it because the second field was a date
set to autofill with the current date. Once I got to playing with the
records, it behaved as you described.

Thanks.

Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.