looping through all items in a combobox

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Hawkide - 18 Feb 2005 18:19 GMT

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?

Reply to this Message

Dirk Goldgar - 18 Feb 2005 18:32 GMT

> Access 97
> I have a combobox on a form.
[quoted text clipped - 3 lines]
>
> How can I loop through each of the items in the combobox?

To do what? Check out the ItemData, ListCount, and Column properties of
the combo box.

Signature

Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Reply to this Message

Hawkide - 18 Feb 2005 18:57 GMT

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...

> > Access 97
> > I have a combobox on a form.
[quoted text clipped - 6 lines]
> To do what? Check out the ItemData, ListCount, and Column properties of
> the combo box.

Reply to this Message

Dirk Goldgar - 18 Feb 2005 19:04 GMT

> 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
[quoted text clipped - 3 lines]
> 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...

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

Signature

Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Reply to this Message