List Box Question

  • Thread starter Thread starter Jay
  • Start date Start date
J

Jay

I have a list box set to display 15 rows. The underlying table has 45
records so the user has to use the scroll bars to select some options. The
problem is the list remains at the point moved to when the user moves to add
a new record.

How can I get the list box to return to displaying the first 15 values in
the source list, after moving to a new record?

Many thanks,


Jason
 
Jay

Have you tried something like:
Me!YourListBox.Requery

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Hi Jeff,

Yes, I've tried Me!lstmybox.Requery, setting it to = null, but neither
works?

Jay
 
I'm stumped. Got any more details...? Like, where are you trying that? Do
you get any error messages? ...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Jay said:
Hi Jeff,

Yes, I've tried Me!lstmybox.Requery, setting it to = null, but
neither works?
Click to expand...

You can do it by reassigning the RowSource; e.g.,

With Me.lstMyBox
.RowSource = .RowSource
End With
 
You must log in or register to reply here.

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

Limiting list box selection 2
Anyone Else Facing Public Folder Migration Errors in Exchange? 0
Clear List Boxes on New Record 4
Drag in a List Box 4
List Box 4
Combo box begining row in dropdown 6
Blank combo or list box 1
How to update a combo box with a query 4

Back
Top