quick approach question, thanks

[BradMiller]

i have a combobox and i want to print a report based on each choice in the combobox.

i was thinking i could stuff all the values into an array.

is that a bad approach? should i instead open a recordset the combobox is based on and just move through it printing each one.

Thanks! Thought I'd bounce this approach off ya'll

i know how to do the second approach, but im not sure how about stuffing an array with a combobox's values if anyone wants to show me how. =)

 

[chrissie1]

try this

for x = 0 to combo.listcount - 1
sql = combo.columns(0,x)
next x

"What a wonderfull world" - Louis armstrong