Access 2010 Combo Box Control Source

[orangeregalbegal]

I have two forms. Both contain combo boxes and sub forms. One works the other does not (the filtering on the combo box). I have examined every property of combo boxes and noticed one difference. ComboBox A (the one that works) has a control source list (the drop down list on the properties sheet) that is limited to the fields from the table of the Row Source. The other ComboBoxB has a control source list of ever field on the form. There field "Part_nbr" is in the long list for CombBoxB but it is not specific to a particular table (its also on the row source table). I have tried clicking the build button and get an error. Actually...I've tried everything...

What is the difference? Thanks for your help.

 

[GinaWhipp]

Check the Row Source and the Row Source Type. It seems like one must say Table Fields. I really can't tell as I'm using my laptop and the images are not that big.

 

[orangeregalbegal]

Thank you Gina, I figured it out. To constrain the Control Source drop down list items, I had to - Design View of the form --> Add Existing Fields---->Show All tables and then select the appropriate table.

 

[GinaWhipp]

Oh okay... I was having a hard time *seeing* the image but you got it working so great job!