Combo box in form

[Guest]

Hello

i understand that when creating a combo box in a form, a wizard will pop up and ask u to choose some options.
i want a "search" combo box, so i should choose the third option.. (Find a record on my form based on the value I selected in my combo box

But my wizard only shows two options in the form i'm working on.

however, when i do it in another form, i am able to see this third option.
why is this so?? Has it anything to do with the tables
because the form which the combo box worked had data extracted from a single table
the form which the combo box couldn't work needed data from different tables

Any help is appreciated! thanx!!

 

[Albert D. Kallal]

In access 97, for some strange reason, if your form is based on a
query...then you don't get the 3rd option.

You can either temporary change the form's data source back to a table, and
then run the wizard.

Or, simply use the wizard to build the combo box..and then add in the code
to "move" to a record yourself.

(just steal the code from an existing combo and change the field names if
you don't know how to write this).

As far as I know..versions after access97 do give all 3 choices...even when
the form is based on a query...