Control Source in Property sheet

[clubinski]

Hello,

my question is in Access 2010 I am currently in the property sheet at a combo list i just added to a form to be more percise with the data the user will look for. My question is I know I have to be in Control source in order for the combo box to select the data that I entered from the table. When i click the arrow the drop list is empty and then when I click the elipses (three dots) it takes me into expression builder, so i am confused on what I should do to select the field I want the combo box to focus on.

Thanks,
Chris Lubinski

 

[boblarson]

Chris:

The control source is the place where you select which field you want to bind the combo to in the table you are storing the data in. The form should have a record source (table, query, or select statement) and then you just select from the drop down. No need to click on the ellipsis next to that one.

The ROW SOURCE is the place you would click on the ellipsis to select the table or query which has the data you want to have the choices come from.

 

[clubinski]

Chris:

The control source is the place where you select which field you want to bind the combo to in the table you are storing the data in. The form should have a record source (table, query, or select statement) and then you just select from the drop down. No need to click on the ellipsis next to that one.

The ROW SOURCE is the place you would click on the ellipsis to select the table or query which has the data you want to have the choices come from.

Bob:
Thanks!