Problem setting up a combo box to find a record on my form.

Usually when I add a Combo Box to the a form the wizard asks "How do you want your combo box to get its values?". Then I can choose
  "I want the combo box to get the values from another table or query."
  "I will type in the values that I want."
  "find a record on my form, based on the value selected in my combo box."

Now today I add a combo box to a form and only get two options.

"I want the combo box to get the values from another table or query."
"I will type in the values that I want."

But I want "find a record on my form, based on the value selected in my combo box."

Can anybody explain why on this form, which is based on a query, I do not get the required option?
Fritz PaulAsked:
Who is Participating?
 
PatHartmanConnect With a Mentor Commented:
The form needs to be bound for this option to appear.
0
 
Dale FyeCommented:
The "find a record on my form" is in the next part of the wizard, not in the section asking where you want to get your values from.
0
 
Fritz PaulAuthor Commented:
I still don't understand, but I made it work based on your tip.
The data source was a table which I sorted where I defined the source. It only gave the two options.
Then I made the data source just the table and arranged the sorting in the form definition. Then it worked.
So in both cases it was bound as I understand it.
Regards,
0
 
PatHartmanCommented:
If the FORM doesn't have a table or query as it's RecordSource, then the combo only gives you the two options.  How can it find a record on a form that isn't bound?  So adding the RecordSource to the form is what makes the third option available.

The combo itself is bound to the RowSource which is what produces the list of choices to pick from.  It may also be bound to a field if the ControlSource shows a column from the Form's RecordSource.  When the combo is bound to a field, It will display or update the field as necessary.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.