Go to combo box missing 3rd option

  • Thread starter Thread starter Caroline
  • Start date Start date
C

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
 
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
Click to expand...

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.
 
A form can also be bound to a SQL Statement. I have found that this type of
record source removes the third option.
 
Back
Top