[AccessD] Combo box default value

Charlotte Foust cfoust at infostatsystems.com
Tue Oct 9 18:22:36 CDT 2007


The simple express is ItemData(0) unless you have turned on column
headings in the dropdown and then it's ItemData(1), since zero is the
heading row.

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Tuesday, October 09, 2007 11:11 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Combo box default value

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.

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list