Thanks very nuch.

I put the line you provided (changing the names to suit)
into the code for the "onOpen" event for the form.
I checked it against the table to confirm it gave the right value.

This form will be a pop-up form to inform the user what the currently
highest and next number is avaliable. This is so they can key it in manually.
The reason for keying it in manually is that when Digital projects are
entered in, they are archived to dvdr. Depending on the size of the project
folder, more than one project may be archived on the same disk.
Also the volume number field is also used for drawings to indicate what
folder they are in (The media field tells if it is dvd or physical folder).

Thanks very much.