Problem with a simple combo box?

[Rich_B]

Hi

I'm new to Access, intermediate with Excel.

I am trying to get an Access form control combo box to display the values from a table field.

In design view of the form I select the combo box and in the property sheet under the Data tab I hit the three dots button against Control Source and in the Expression Builder I select the table from which I want the combo box values then I select the field name and values so that it all appears in the window above. I hit OK and save but when I return to the form view of the form the drop down menu of the combo box is blank.

Where am I going wrong?

Access 2007
Win 7
PC

Thank you

 

[plog]

I am trying to get an Access form control combo box to display the values from a table field.

To achieve this you would go to the Data tab and put the name of the table in the Row Source drop down, not the Control Source.

The Control Source ties it back to the specific field of the Record Source on the forms Data tab.

 

[Rich_B]

To achieve this you would go to the Data tab and put the name of the table in the Row Source drop down, not the Control Source.

The Control Source ties it back to the specific field of the Record Source on the forms Data tab.

Hi Plog

Thank you very much, that worked perfectly.

Do you happen to know why the order of the options in the combo box list is different to the order they are stored in the table?

I would like them to be ordered the same if possible.

 

[plog]

There is no order in a table. Order exists on data only when you specifically tell it to be ordered.

So, if you want the data to be ordered in your combo box, you should create a query, apply order there by bringing down the field to order by, change the Sort field underneath it to either Ascending/Descending, and then use that query as the Row Source of the drop down.