How to Show AutoNumber Value in Form

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?

re: How to Show AutoNumber Value in Form

DHRRush wrote:[color=blue]
> 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?[/color]

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

re: How to Show AutoNumber Value in Form

DHRRush wrote:[color=blue]
> 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?[/color]

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)

re: How to Show AutoNumber Value in Form

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.

re: How to Show AutoNumber Value in Form

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.