afterupdate expression

[warco]

I am trying to build an expression using the afterupdate() function in an expression (not VBA). Can anyone give me an example of an expression that increments the field [batch#] +1 after the update. Any alternate suggestions for my expression would also be helpful. I've thought about using dmax(), but my [batch#] field tends to jump around.

 

[Pat Hartman]

!. AfterUpdate is the wrong event to use. The record is already updated so it is too late to assign a batchNum. And it's too early to assign a batchNum for the next batch because no one has started inputting it yet.
2. You need to use VBA and you need to worrry about multiple users addtmpting to assign a batch number at the same time.
3. If your batchNum field jumps around, how would you decide what the next number should be?
4. Using special characters or embedded spaces in field names is poor practice.

There are many posts here with suggested code for generating your own sequence numbers.