Consecutive numbering using down arrow

  • Thread starter Thread starter sgmellen
  • Start date Start date
S

sgmellen

Back in Access 2003 (and previous versions), you could start typing a number
in a column in a query (or table), show Access the pattern, and then as you
pressed the down arrow, it would automatically continue the series. For
example, if I had a column of, say, item numbers, I could sort the query as I
wanted it, type a "1" in the first record, a "2" in the next one down, then
all I had to do was press the down arrow and Access would continue with 3, 4,
5, etc. This isn't working in 2007! Anyone know how to make it?

I know this is pretty rudimentary and there's probably a way to code the
behavior. I'm not much of a VBA whiz but I'm willing to learn!
 
sgmellen,

Umm, they moved that *mis*feature. However, judging by your description
sounds like you are using a table for data entry. If this is true, quit
that and use a form... You really don't want to do anything in the table.
Using a form you can use DMax("YourIDField","YourTable")+1 on the Before
Update event of the form and achieve the same thing.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 
Back
Top