Hi Guys,

I am new to VB and am having trouble loading a combo box with DB values. Don't have the DBCombo component so am doing it the hard way.

Set myDB = OpenDatabase("c:\Defects\Defects97.mdb")
Set rst = myDB.OpenRecordset("Select * From MajorComponents")
rstc = rst.RecordCount

For rstx = 0 To rstc - 1
Combo1.AddItem rst!MajorComponents & ""
rst.MoveNext
Next
rst.Close

This code almost works. It generates the following error message:
"Object doesn't support this property or method" but still loads some of the records (first 3).

I'd appreciate some help.

Cheers