List Box go to first record

M

Martin

Hello,

I have two list boxes based, the second based on the results of the first.
This works fine. However, I want to automatically select the first record in
the second list box after the first one has been clicked on by the user. I
just cant think how to do this. Here is what I have on the click property of
the first list box:

Me.Refresh
DoCmd.GoToControl "List2"
'DoCmd.GoToRecord , , acFirst

Cananyone help?
 
M

Marshall Barton

Martin said:
I have two list boxes based, the second based on the results of the first.
This works fine. However, I want to automatically select the first record in
the second list box after the first one has been clicked on by the user. I
just cant think how to do this. Here is what I have on the click property of
the first list box:

Me.Refresh
DoCmd.GoToControl "List2"
'DoCmd.GoToRecord , , acFirst
Click to expand...


Scrap that stuff an use list1's AfterUpdate event procedure:

Me.List2.Requery
Me.List2 = Me.List2.Itemdata(0)
 
M

Martin

Marsh, thanks for your help.

Martin

Marshall Barton said:
Scrap that stuff an use list1's AfterUpdate event procedure:

Me.List2.Requery
Me.List2 = Me.List2.Itemdata(0)
Click to expand...
 

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

Form opening to new record 3
Going to first record 0
Select 1st Item in Listbox 2
Problem DoCmd.GoToRecord with tabbed pages 1
First record on sub form 2
Compile error on Combo box: Method or data member not found 2
On Error Problem 3
filter one list box based on another 3

Top