How do I use the ComboBox object in vba in a table?

[smiler2505]

I know it's a strange request to want to use a combobox in a table rather than a form, but if it's possible it would be good.

I know there is a ComboBox object, but all the useful references such as LimitToList do not work. I've tried the following also, and although it throws up no errors it does not appear to make a combo box.

  Set fmtfCNum = fldCNum.CreateProperty("DisplayControl", dbText, "Combo Box")
   fldCNum.Properties.Append fmtfCNum
  Set fmtfCNum = fldCNum.CreateProperty("RowSource", dbText, "SELECT tblCen.CNum FROM tblCen;")
   fldCNum.Properties.Append fmtfCNum
  Set fmtfCNum = fldCNum.CreateProperty("ListRows", dbInteger, "255")
   fldCNum.Properties.Append fmtfCNum
  Set fmtfCNum = fldCNum.CreateProperty("LimitToList", dbBoolean, True)
   fldCNum.Properties.Append fmtfCNum
 

Edit:
Yet again, after an hour and a half searching, as soon as I ask a question I find the answer: http://support.microsoft.com/kb/304274

[MMcCarthy]

Isn't that always the way :)