Combo box in form

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!!
 
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...
 
Back
Top