Adding the records from a recordset

[GerardMcL]

Hi,

I have my rs all set up and full of data but cant get more than one item into the checkbox.

While rs.eof = False
cmbTools.Value = rs("ToolID")
rs.MoveNext
Wend

I know this doesnt work but Im used to VB6 and cant find the AddItem or a similar function here.

Thanks for the help!

 

[PHV]

Why not use SQL code as RowSource ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Zion7]

I assume you meant ComboBox, not checkBox,
But as PHV said, SQL statement seems the most appropriate
for what you implied your objective was.

Otherwise, look into the AddItem and RemoveItem methods,
for ComboBoxes & listBoxes, from VBA help