Multiple defaults to a field in a form.

[myme]

How do I set multiple sequential (or order I set) defaults to one field when adding new records. Example: When adding new customers to a form, there is a sales person ( out of 5) assigned to the record automatically and it needs to be in a order that can be set. Obviously I can set one sales person automatically when a new record (customer) is added, but I have not been able to set multiple defaults in an order I can set. Thanks

 

[jfgambit]

You could use a Select Case Statement:

Here is a really crude example...I put this together in about 5 minutes...so don't expect anything to exciting...

 

[myme]

Thanks, that is closer to what i want, but do you know how for instance when you add a record, "John" is the default for the salesman field. The next time you add a record "Brenda" is the default and so on. These names need to be auto put in the field as the new record is being created. The thing is each salesperson needs to be assigned to a record (client) automatically so there is no favoritism and it rotates depending on how many salespersons there are. thanks

 

[Kodo]

sounds like you want something to randomly choose who the salse-person is?

 

[myme]

Yea, do you have an idea of how to accomplish that?

 

[Mile-O]

In the employees table you can add one field (a simple Yes/No) for next assignation. On the update of a new record, a small routine, which I'll see if I can dig out, moves the checkbox to the next person. Once at the end of the recordset it moves the checkbox to the first person.

 

[Kodo]

Yea, do you have an idea of how to accomplish that?

perhaps this might point you in the right direction for randomizing.
http://www.fontstuff.com/vba/vbatut02.htm