How to re-set index in a list box?

X

Xfen

Hi there,

I want to re-set the index to 0 after each use of a list
box. My code is like this:

Me!List1.ListIndex = 0

I get run time error because the use of ListIndex is
incorrect.

What is the correct way?

Thanks.
 
B

Bruce M. Thompson

I want to re-set the index to 0 after each use of a list
box. My code is like this:

Me!List1.ListIndex = 0
Click to expand...

Try:

Me.List1.Value = Me.List1.ItemData(Abs(Me.List1.ColumnHeads))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Re-title multiple MS Project .mpp files at once 0
Clear list box selection 4
Combine Lists 1
VBA Coding Help for Beginner 0
Insert Index into a Table 1
Making a macro only work on certain files 2
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Runtime error 91: Object variable or With block variable not set 8

Top