start a new record by selecting an item from a combo box

[lkennemur]

I have a combo box that I want to select from. I want to select an item and have the values populate some text boxes with some info. but I want it to be recognized as a new record. For ex:

OperatorID Last Name First Name Survey Date Machine
001 Jones Bob 5/5/2005 1


Contact Info.
555-555-6666

Is there a way to select an operator and his information, populate text boxes with that information, and have it recognized as a new record so that they can enter in a new date and new machine and update any info. (as a new record)?????
How do I need to design this?

Thanks

 

[PHV]

Have a look at the Column property of the ComboBox object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886