Populating a drop down box with a recordset

gellerche

Registered User.
Local time
Today, 13:11
Joined
Jun 19, 2001
Messages
73
I am using VBScript behind a form, and want to populate a drop-down box with one of the recordsets I create in the form. I am trying to add it like this (AppObj is the rs), cmbApplication is the dropdown):

Do While Not AppObj.EOF
cmbApplication.AddItem(AppObj("Name"))
AppObj.MoveNext
Loop

, but I can't find anything like "AddItem". If someone could tell me how, I'd appreciate it.

Thank you,

Steve Geller
 
What you need to set is the combobox's Row Source. The best way is probably to build an SQL statement.

BL
hth
 
Thank you for your help. Once I set the RowSourceType for the drop-down, it worked like a charm.

Steve
 

Users who are viewing this thread

Back
Top Bottom