[AccessD] Combo box default value

You could count the actual entries in the table (not in the lookup table)
and select top 1 descending: Here's an example drawn from one of my apps.

SELECT TOP 1 LightCurtainData_tbl.CompanyID, Count([CompanyID]) AS
Occurrences
FROM LightCurtainData_tbl
GROUP BY CompanyID
Order By Count([CompanyID]) DESC

Edit to suit, save as a named query. Use Dlookup() to obtain the value. Make
the default value of the combo "=Dlookup("[CompanyID]",
"LightCurtainData_tbl") in this case. Substitute your own values for the
table and columns and you're away to the races. I just whipped up a sample
form to test it and it works as advertised.

hth,
Arthur

On 10/9/07, David and Joanne Gould <dajomigo at dgsolutions.net.au> wrote:
>
> 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.
>
> Hope this makes more sense.
>
> David
>
>