Limited incrementation

[DevRev]

Hi I am a noob and I'm having problems performing a particuler form.

I need a form that will auto-increment records as they are ented from 1 to 20 but once I have receached 20 I need it to start over at 1. So no record will have a higher number than 20 in this particular field.

Any help would be greatly apprciated.

 

[WayneRyan]

Dev,

Obviously you have some other field that will be incremented once you reach
20. Use the BeforeInsert event and use the DMax function to find the current
highest value.

Use the Search feature here and look for DMax.

Wayne