>David, thanks for the reply. I'm using the first table for values that will be stored in the second table. The values should be stored when the combo is exited (LostFocus - ?)
(You might try using the builder to see if it'll get the combo working closely to what you want.)
If you really want to store two or more values from the combo into the desired table, then in the LostFocus (or Valid or InteractiveChange) for the combo, put the following code. (Assuming combo is set to return value from column1)
mytable.field1 = thisform.mycombo.value
mytable.field2 = thisform.mycombo.list(thisform.mycombo.listindex,2)
"The Iron Fish: The water is cold...but the fish don't mind"
...Jay Jenks, boyhood chum