Navigating with combo Boxes

[Peppboy]

while trying to design a formI would like to use a dropdown box to find an
item and then have it fill in all the fields from that dropdown choice. wen
refering to "The Missing Manual for Access 2007, the write that when you
create a combo box with the Control Wizard On, the user will get a first
screen that offers 3 choices. When I do it, I only get 2 choices, and the
"Find a record on my form based onthe valueI selected in my list box" choice
is not present. What am I doing wrong?

 

[Arvin Meyer [MVP]]

Your list box is bound to your data. You cannot use it to lookup data if it
is bound to a field. List and Combo boxes have 2 types of binding. The
binding in the controlsource property must be blank (unbound). The other
binding is the value that the combo or list box returns when selected.

 

[Linq Adams via AccessMonster.com]

Other possibility, of course, is that the form hasn't been bound to a Record
Source at all! The third Option then will also be missing.