Add Randomize to your code (below the variable declarations).

Random
Random Records

It's the randomize function i think I'm looking for.

Good day Y'all
If its an id look under the autonumber. You have another option under the general tap look for replication ID.  I think that is an option you can use or go get the ABCD databse where richard generats an entity number which is random but cheks to make sure its not also in the database.

Other option is what I use to track my projects I use julian date with Year and a four digit increment to show what the year last 2 digits day is was created and last four increase by one.  It also checks to see if the previous date is less than system date if true it resets the last four to 0000.
My format looks looks this 243640000 by looking at the number I can tell 24 is 2024, 364 is the day of the year and last four you can make 0 base or 1 base to increment on every project you add that day.

Could you put the random number generator inside a loop that will also evaluate if that tracking number has already been assigned, through a DLOOKUP?   If it has, just rerun the loop.

Sorry if I don't sound totally functional right now.  No coffee yet.

It's not an auto number.  

The Droid, I mean the code I was looking for was the randomizer.  

For reasons I don't want to get into I'm want the "Invoice" transaction to tracked as yyyyddmm and 4 random numbers from 0000 to 99999 (I'm never going to have more than 9999 "transactions" in a day - Heck I won't even hit 500 for a day).  Before I post the entry I do have it Dloopup the TransactionRegisterTbl (I use Tbl for Tables instead of T) and if it does find a match I get a msgbox telling me the numbers been used before, and then it tries again.    

The Randomizer from the vault with a small change does the trick and gives the "customer" the illusion I'm looking for.  

Now I'm either going to compile some Coffee!

then you have the right idea throw it into a if statement have it check and if not used then pop it into a field.  I recomend a record set for speed.  Hope this helped.