See the help file for ADO's recordset's .Open method to define a recordset
against your .mdb.  Once you've got that, you just loop through until .EOF,
calling .AddItem all the way.

HTH,

-Roy

Roy Pardee
Programmer/Analyst
SWFPAC Lockheed Martin IT
Extension 8487

-----Original Message-----
From: Nigel Spicer [mailto:spicerman@t...]
Sent: Friday, November 09, 2001 5:01 PM
To: professional vb
Subject: [pro_vb] How do I load Access list into Combobox?


Hi there I was wondering what is the code to load a list of names from 
Table "Customers", Field "Name", of a MDB access file into combo1.additem 
on form load event?

Nigel...