How to Show AutoNumber Value in Form

[DHRRush]

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?

[Rick Brandt]

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

[MGFoster]

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)

[DHRRush]

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.

[DHRRush]

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.