Hi All
I have a table "tblGlobeCode" that has 999 records ranging obviously from 1 to 999 (The field is called "GlobeNo)". each of these numbers identifies an Acc number along with a note regarding the acc number.
Currently there are acc numbers assigned to 500 of these records, the rest are unassigned. ALSO they assigned numbers are intermitant so we are trying to "fill the gaps".
I have used a select query to find all the unassigned GlobeNo's and sorted them in ascending order.
WHAT I NEED!!
When a new account number is being entered into the DB it will need to be assigned a GlobeNo. I am going to use a button. What I need the button to do is Find the first available GlobeNo and append the Acc Number to that record in the "tblGlobeCode". Also, directly afterwards if a MsgBox could appear to tell the user what GlobeNo was assigned to it.
Hope this can be sorted!!