Combobox Columns

[Guest]

I'm having trouble with a multi-column combobox. I din't know why, it's
something I've done a million times before.

The control source is bound to the field I wish to update. Bound columns is
set to 1. Column count is set to 1, Widths 0cm;3cm. The Row Source is:

SELECT tblTaskType.TaskTypeID, tblTaskType.TaskTypeName FROM tblTaskType;

I've also tried SELECT DISTINCT, and tried with or without the tblTaskType
prefix. No selections are available in the combobox. What else can I check?

Thanks

Dave

 

[Roger Carlson]

Column count should be 2

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

So simple and I couldn't see it. Thanks.

Dave

Column count should be 2

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L