Can't seen to get a simple lookup combo box working?

[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

 

[Norie]

It's RowSource and RowSource type you should be using to populate your combobox.

 

[Rich_B]

It's RowSource and RowSource type you should be using to populate your combobox.

Thank you very much.

Do you know why the items in the list are displaying in a different order to what they are in the table? I have them sorted how I want them in the table used as the source for the combo box but when they display in the combo box they are all mixed up.

 

[Norie]

If you want to ensure the data is displayed in a certain order use a query based on the table for the row source of the combobox.