Unbound contols after using Combo box wizard

[Lou_Reed]

When I go the Combo box wizard to create a combo box it works - sometimes. I repeat the


steps exactly and sometime it gives the name of the control in the window and sometimes it does not.

I am unsure as to what I am doing wrong on this. I can post an example if required.

All help appreciated. Thanks in advance.


Respectfully,

Lou Reed

[ranman256]

after you build the combo, check the name in the properties: other tab, name
also check ROWSOURCE (the query to pull the options)
and CONTROL SOURCE (unbound or put a field to save the selecton to)

once it works, it will never change.

[ItsMe]

As ranman mentioned, check the ControlSource of your combo. When the wizard asks if you want to store the value of the Combo, it is really asking if you want to adjust the control source. A blank control source is an unbound control.

[Lou_Reed]

I know that I can go into the properties dialog box (press F4) and see the properties. If control source is missing, then put it in. But that defeats the whole purpose of the Combo Box wizard. It is bound about 50% of the time and unbound the rest. Still, all I do is follow the steps - nothing more. Yet, part of the time it works and part of the time it does not. What gives would a post of the output help?

Respectfully,

Lou Reed

[June7]

The wizard asks for ControlSource only if the combobox is installed on a BOUND form. If the form does not have a RecordSource, the combobox has nothing to be bound to. Either you are not installing on a BOUND form or you are accepting the default "Remember the value for later use." - which results in an UNBOUND combobox.