Format autonumber

[Guest]

I know that I can format an autonumber for example like this: "KAM-"0000 and
the value will be KAM 0001 .... end so on.
I would like that instead of KAM, a field of a table is shown.
For example (something like this):"customertable!ID-"0000
If yes, how can I do this?
Thanks
Klaus

 

[Al Campagna]

Amateur,
Keep the ID and the Autonumber as they are, but use a calculated, unbound, field to
"display" the "concatenated" value... in any form, query, or report.
= ID & "-" & YourAutoFieldName
If ID = 176, and AutoNum = 1826 then the above will display...
176-1826
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."