drop down city

[Guest]

I need some help to how to create a drop down field from which city that i can choose from that menu

 

[Ken Snell]

Set the row source of the combo box to be a query similar to this:

SELECT [CityName] FROM [TableName] ORDER BY [CityName];