[AccessD] OT - Visual Basic DataCombo Control, Displaying First Item In List

Charlotte Foust cfoust at infostatsystems.com
Thu Nov 17 10:27:25 CST 2005


What you want is something like MyCombo = MyCombo.ItemData(0)

Note that if you have column headings turned on, you need to use
ItemData(1) because the column headings are treated as the first row.

Charlotte Foust


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Paul Hartland
(ISHARP)
Sent: Thursday, November 17, 2005 2:41 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] OT - Visual Basic DataCombo Control,Displaying First
Item In List


To all,

I have a DataCombo control which will vary with the number of records
contained inside it depending on what account number of a particular
client is selected, but I can seem to set it up to display the first
item in a list when the recordset of the DataCombo box is returned..

I did think about using a recordset variable to get the clone of the
recordset and return the first item that way, but this seems long winded
and surely there must be a cleaner more effective way.

Thanks in advance to anyone that can help on this or supply sample code
etc.

Paul Hartland
Database Developer.

-- 
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