I think that will only work if the first column is the bound column,
Clifford. If, for instance, the third column was the bound one, I believe
you'd need to use
=[cbTypeCode].[Column](0,2)
Probably better off to use
=[cbTypeCode].ItemData(0)
--
Doug Steele, Microsoft Access MVP
(no private e-mails, please)
Clifford Bass said:
Hi Jim,
Easiest is to place this in the Default Value property (cbTypeCode
being the name of the combo box in this example):
=[cbTypeCode].[Column](0,0)
Clifford Bass
JimS said:
I swear there's a simple way to make the default value of a combo box the
first item in the itemdata list. I can't remember how. Help?