Refresh List Box (1 Viewer)

[kostaskir]

Hello everybody,

It might look simple ans silly. BUT I really have this problem.

I created a ListBox on my Form where it takes a parameter from an Edit Box and brings me back data from a table. IT WORKS BUT ...

I can't refresh the list box when I press NEXT or PREVIOUS.

On these buttons I wrote : Me.ListBox.Requery.

Do you know guys any other way to refresh my List Box. ?


Thank you.

 

[olxx]

Try just Me.Refresh on your event. It should do the trick.

 

[kostaskir]

I tried it.

It doesn't work.

I don't understand. The SELECT query is correct. It brings me the correct data. It refresh the data only when I press the Edit Value button on the List Box.

I also wrote the Me.Refresh on the OnLoad event of the form.

 

[kostaskir]

Hello,

Finally I did it. I erased all the VB and I replaced it with macros.
On the Next & Previous Buttons I added two macros where they control the navigation and the refresh of the from.

Thank you.