Drop down box pulls from Table

[RichGags]

Ive created a drop down box on my "bookings" form, which pulls its values from a "location" table. How do I have these locations appear alphabetically in the drop down box? Thanks.

 

[soundsfishy]

Go to the data tab in the properties of the dropdown field, then in row source of the dropdown box set the booking field to ascending.

 

[RichGags]

Sorry, but on the Data Tab, Row Source, there is not option for Ascending. It is only giving me a list of the tables to pull the data from. Maybe Im not looking in the right place?

 

[soundsfishy]

Ok. ! where the row source, click the elipse ... and in the field that holds the values there should be a sort criteria . Set it to ascending. Give that a try.

 

[RichGags]

ok got it thanks! I had to use the Query builder.