not really. It can be done but it would require code to do
it. reason is that with the prefix, it is no longer a
number, access considers it text and that makes it
difficult to add 1 to it for the next number.
It would be better to keep the autonumber a number in the
table. you could then concatinate your prefix with the
autonumber in queries and reports:
SELECT "COSHM-" & [autonumber] AS RecordID
FROM yourtable
WHERE Something = something
You could do this in your forms too but in the table in
would just be a number and that is best.
note: if you try to relink the concatinated query with the
table, you will get a type mismatch if you try to link the
concatinated autonumber with the table autonumber. see
reason above. number linked to text = error.
