I have been fighting with this and looking around the net for hours
now.

I have added a combo box to a form.
Row Source Type - Table/Query
Row Source - Select [Contact Types].ContactTypeID, [Contact
Types].ContactType from [Contact Types]
Column count - 2
bound column - 0

The query works fine by itself, I have
[Forms]![frmAffiliates]![cboSelect] as a query parameter. When I click
the query, the parameter box opens, I type a value and my query runs
great.

When I run the form with the combo box, I click the drop down arrow
and the box opens, it is populated with all my entries.

PROBLEM: But when I click on a selection in the box, nothing gets
selected and the cbo box does not close back up, it just sits open.

I added Event code to the AfterUpdate event to open "msgbox cboSelect"
but this does not popup.

Does anyone have any idea why this box will not work. I tried
substituting a list box but get similar results.

Thanks for any ideas

Try setting the BoundCoulmn to 1 not 0.

- Andrew Backer

Mark wrote: