I have a problem Houston

[Lou_Reed]

Okay, I have solved the problem of the Combo Box Wizard. I think.

I select the option to let me type in the options in the drop down box.


It then gives me in the next panel the column to type those values in and that is what I what I do.

Finally, I slect the control source. Again, the control source is entered last.

Then I saved the form and change it to form view.

Now when I click on the down arrow in one of those combo boxes the SQL code shows up, not the
choices that I typed in.

What am I doing wrong? Should I select the control source first? I already have the record source selected for the form?

Any help appreciated. Thanks in advance.

Respectfully,




Lou Reed

[June7]

What exactly do you have in the properties:

RowSource
RowSourceType
ControlSource
BoundColumn
ColumnCount
ColumnWidths

[Lou_Reed]

I think that I know the problem and how to solve it.
I started off the Combo Box Wizard and selected that I
wanted to type in the values myself. I, then, instead of clicking finish, I clicked next.

It gave me two choices about remembering the value. I chose the first one.

I then went to the final panel and typed in a name.

This worked.


Now when I select the drop down arrow all of my choices are there..

not SQL code.

It works.

Respectfully,


Lou Reed