populate field using next available number

[clare_voiant]

Hi,

I have a lookup table containing consecutive numbers and a yes/no box to say whether or not the number has been issued already.

It is important that the numbers are issued in order and that all the numbers are issued.

I would like to be able to either select (using a combo box) the next unissued number (then mark it as issued) OR to be able to use a button command to 'get number' to get the next previously unissued number and then mark it issued.

My coding is limited. please help.

many thanks

Clare



thanks Clare

 

[bat17]

to get the highest number used you can use the Dmax function. You would not normaly mark a number as used, if exists it has been used! just find the highest number used and add one.

in a form that uses the number you can set it default value using the Dmx() function and it will add the next number when the record is created
=DMax("[ID Field]","[Your Table]")+1

This will only work on a single user form as in a multiple user set-up more than 1 person may try to add records at the same time.

HTH

Peter