looping through all items in a combobox

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Access 97
I have a combobox on a form.

The row source for the combobox comes from a SQL statement that queries a
table.

How can I loop through each of the items in the combobox?
 
Hawkide said:
Access 97
I have a combobox on a form.

The row source for the combobox comes from a SQL statement that
queries a table.

How can I loop through each of the items in the combobox?
Click to expand...

To do what? Check out the ItemData, ListCount, and Column properties of
the combo box.
 
Well, each item represents a report. I want to print each report. The bound
column is column(0), but column(1) has the name of the report. It is the
string value in column(1) that I am interested in.

Basically, I am going to run this code from a "Print All Reports" button.
I'll take a look at your suggestions. If you think I need anything else,
please let me know. Thanks so much for your help...
 
Hawkide said:
Well, each item represents a report. I want to print each report.
The bound column is column(0), but column(1) has the name of the
report. It is the string value in column(1) that I am interested in.

Basically, I am going to run this code from a "Print All Reports"
button. I'll take a look at your suggestions. If you think I need
anything else, please let me know. Thanks so much for your help...
Click to expand...

It sounds to me like you know how to do it now. Post back if you run
into any snags.
 
Back
Top