Susan Harkins
ssharkins at gmail.com
Tue Oct 9 13:10:59 CDT 2007
The query sorts by most often chosen? That's interesting -- so the most often chosen should be the top item in the combo right? If that's the case, you simply set the default value to the first item -- there's a simple expression for doing so that I can't recall off the top of my head -- someone's going to know it -- control.Data(0) or something like that. Susan H. > Steve > > The combo box is based on a query that lists departure points for a > tour bus based on the postcode of the client. It lists the options by > most popular to least popular. At the moment it starts off with a > blank text box and I want it to show the most popular as a default. > The combo works fine as far as listing the options in the right order > - just leaves it blank until a choice is made.