checkbox to generate control number

[soulpiercing]

Help!

The work I do requires that I assign control numbers but only in certain circumstances depending on the final resolution of cases. What I want to do is have a checkbox that will, once checked, generate a control number.

Issues:

If the box is unchecked after being checked, I do not want other numbers to adjust - either the number should remain or be deleted and have a missing number in the log.

Also, if unchecked then checked again, I do not want another number to be assigned.

Is this possible?

Thanks

 

[Jack Cowley]

The short answer is Yes. Use DMax() or DLookup() to get the value you need to assign from a table that has the next available number. Save the value in a global variable if you decide to use it after discarding the number by unchecking the checkbox. Clear the variable when you leave the form or at some other appropriate time.

hth,
Jack