Problem #1) I need a text field CRNo on form frmChangeImpact to autonumber/format to YY-### and reset at the beginning of each year. Is this possible?
-
Last edited by zmbd; Oct 25 '15, 05:10 AM. Reason: [z{deleted second question. One Question per thread please. :) see FAQ.}] -
I answered problem #1 by making a subform which calls up a query expression.Last edited by zmbd; Oct 25 '15, 05:11 AM. Reason: [z{deleted second question. One question per thread please - see FAQ}] -
That is one solution and there are a few other threads covering similar needs to your request. Please use the site's search feature :) and the following Key words:
Serial numbers, sequence numbers, year
To get you started here is one: http://bytes.com/topic/access/answer...increments-one
NeoPa's suggestion in Post#6 is a very good one to use
and there are many others... it's a common need. :-)Comment
Comment