I know there is a way to do this simply! I have a combo box to pick a company. When the company is selected I want the corresponding agent's name and phone number to drop in. I remember the code in the data source property to be something like [cmboboxname].[column].(1) but I can't get any variation to work.
thanks for any help!

=[Combo].[column](x)

Remember that they start from 0, not 1.

HTH,
David R