Incrementing on a form

[Guest]

Hello, first poster. My question is this:

I am working on a cemetery database, I have only one table and one form at
this point. On my form, I want to auto-increment the number in the Grave
field based on the number in the Row field.

For example, There are 50 graves in the first row, instead of having to
manually keep up with what grave I'm on I'd like the form to autoinsert the
next number as long as the row didn't change. When the row goes to 2, I'd
like the grave number to start over again at 1.
I am new to VBA, but used to working with Access. Any help or advice to
where I can find some learning material online for VBA would be a great help
also, as I would like to become proficient in the VBA language. Thanks!

 

[Lynn Trapp]

Tracy,
Let me suggest that you start by looking for information in Help on the DMax
function. This will allow you to select the maximum value of some field
based on a criteria, which can be the value of your row field.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html