Go to combo box missing 3rd option

[Caroline]

I want to add a combo box that would let me pick a value and depending on my
choice would take me to that record.
I was able to do it in one database and not in another because in the new
database, the 3rd option in the wizard is not visible ("Find a record on my
form based on the value I selected in my combo box"). How do I bring it back?
Thank you,
Caroline

 

[fredg]

I want to add a combo box that would let me pick a value and depending on my
choice would take me to that record.
I was able to do it in one database and not in another because in the new
database, the 3rd option in the wizard is not visible ("Find a record on my
form based on the value I selected in my combo box"). How do I bring it back?
Thank you,
Caroline

That 3rd combo option is only available if the form is bound to a
table or query.
How could the combo find a record ... etc... if the form doesn't have
any records to find?

Set the form's record source to a table or query and try adding the
combo again.

 

[Duane Hookom]

A form can also be bound to a SQL Statement. I have found that this type of
record source removes the third option.