spreadsheets within combo boxes

[jiminy]

I would like to put a combo box onto my form. The associated table has one field that has different spreadsheets as objects for some of the records. I would like the user to be able to choose a record from the first column (name of a publication), and see the spreadsheet of data in the 2nd column. When I try to create the combo box, the field with the spreadsheets is not given as an option to choose from. Is there another way I can get the same results?

 

[Remou]

You can set a textbox to:

=NameOfCombobox.Column(1)

Where numbering starts from zero. Is this what you mean?

 

[PHV]

You really want an OLE field in a COMBO ????

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886