How do I set up a random number generator?

[Jay]

First of all, a while back I created a database of employees and I assigned
them numbers (not related to any "real" data). Then I created a Function in
VB and created the number generation part; however, I didn't tie the
generating number to the employees in the DB. Obviously I didn't think it
all the way through and I'm looking for suggestions from anyone willing to
help. Otherwise I'll spend valuable time on something which is most likely
the simplest task.
How do I connect the random number generator to the list of employees?

 

[Merv]

Jay,

If you are using Access, all you need to do is change the field type for
your employee ID field to AutoNumber. It will assign a number to each field.
You can change the arguments depending on whether you want it to be a
sequential number or a random number. This is what will be added if you
design a table w/o a primary key.

 

[Arvin Meyer]

Set the DefaultValue property of the textbox which is bound to the the
employee number:

=YourFunctionName()
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access