Changing info on List Boxes

[unisysce]

First of all thanks for looking. I have a form with a field called CustomerName. On this form I have 3 list boxes (Open, Done, Closed) that look at query that points to the CustomerName field to display just the data that belongs to that client. When I open the form, the list boxes show the info for the first client. When I move to the next record, the list boxes don't change. They continue to show the info of the first client. I need this to change everytime I move to a new client.

Thanks for the help.

 

[TheAceMan1]

How are ya unisysce . . .

In the [blue]On Current[/blue] event of the form, copy/paste the following:

[blue]   Me![purple][b][i]ListboxName1[/i][/b][/purple].Requery
   Me![purple][b][i]ListboxName2[/i][/b][/purple].Requery
   Me![purple][b][i]ListboxName3[/i][/b][/purple].Requery[/blue]

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[TheAceMan1]

unisysce . . .

So sorry!, my previous post wont work. Try

[blue]   Me![purple][b][i]ListboxName1[/i][/b][/purple].RowSource = Me![purple][b][i]ListboxName1[/i][/b][/purple].RowSource
   Me![purple][b][i]ListboxName2[/i][/b][/purple].RowSource = Me![purple][b][i]ListboxName2[/i][/b][/purple].RowSource
   Me![purple][b][i]ListboxName3[/i][/b][/purple].RowSource = Me![purple][b][i]ListboxName3[/i][/b][/purple].RowSource[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[unisysce]

Thanks a lot TheAceMan!! It works great. Now if I can double-click the record in the list box and have it open another form I'm set.

Thanks again

 

[TheAceMan1]

unisysce . . .

Have a look at the [blue]DoCmd.OpenForm[/blue] method and enter it in the [blue]After Update[/blue] event of the listbox(s) . . .

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886