?
Solved

loop a list box in access 2013 form

Posted on 2013-06-11
3
Medium Priority
?
635 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 1200 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 800 total points
ID: 39239643
0
 

Author Closing Comment

by:bill201
ID: 39239662
Many thanks
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

If you are a mobile app developer and especially develop hybrid mobile apps then these 4 mistakes you must avoid for hybrid app development to be the more genuine app developer.
A Case Study of using the Windows API to provide RS232 communications capability in Access without the use of Active-X controls.
Starting up a Project
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

578 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