Combo wizard disappear

[Guest]

My combo box wizard has been acting up. I noticed that there was no third
option when I tried to create a combo box in the main form, e.g. Find a
record on my form based on the value I selected in my combo box. I deleted it
and tried it again and the wizard no longer comes up and the box is just
there unbounded. Could someone please tell what happened?

Many thanks.

 

[fredg]

My combo box wizard has been acting up. I noticed that there was no third
option when I tried to create a combo box in the main form, e.g. Find a
record on my form based on the value I selected in my combo box. I deleted it
and tried it again and the wizard no longer comes up and the box is just
there unbounded. Could someone please tell what happened?

Many thanks.

1) The wizard won't appear unless the wizard's tool button is
depressed. It's the Wand with falling stars on the toolbox. It should
be down.

2) The 3rd option "Find a record ..." won't appear unless the form has
a record source. If the form is not bound to a table, how can the
wizard know what fields to include in the combo rowsource?

 

[kounsrey]

Hi Fred,
Thanks for the first one, that helped quite abit and the Combo wizard is
working now.

I am still confused with the second one. I am attempting to make a name
search within a form. The subform within the main form has details linked to
several tables. When I right hand click on the properties of the form, the
record source shows that I have linked it to the appropriate table. I am
attempting to place the combo box in the header section of the form but it's
not working and the third option does not come up. The fact that i put it on
the header section, does it matter?

Thanks in advance!