Solved

loop a list box in access 2013 form

Posted on 2013-06-11
3
608 Views
Last Modified: 2013-06-11
hi


i have a listbox in a form in access and i want to make some stuff on every row in the list box how can i loop the entire list box

how i write while not end of the listbox? and what to write when i want to  move to a next record?
0
Comment
Question by:bill201
3 Comments
 
LVL 29

Accepted Solution

by:
IrogSinta earned 300 total points
ID: 39239642
This may get you started:
   
    Dim i As Integer
    
    For i = 0 To Me.NameOfListbox.ListCount - 1
        Debug.Print Me.NameOfListbox.Column(0, i)
    Next

Open in new window

0
 
LVL 21

Assisted Solution

by:Boyd (HiTechCoach) Trimmell, Microsoft Access MVP
Boyd (HiTechCoach) Trimmell, Microsoft Access MVP earned 200 total points
ID: 39239643
0
 

Author Closing Comment

by:bill201
ID: 39239662
Many thanks
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question