Refresh List Box (1 Viewer)

kostaskir

Registered User.
Local time
Today, 18:32
Joined
Jan 21, 2009
Messages
65
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. ? :confused:


Thank you.
 

olxx

Registered User.
Local time
Today, 08:32
Joined
Oct 2, 2009
Messages
36
Try just Me.Refresh on your event. It should do the trick.
 

kostaskir

Registered User.
Local time
Today, 18:32
Joined
Jan 21, 2009
Messages
65
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

Registered User.
Local time
Today, 18:32
Joined
Jan 21, 2009
Messages
65
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. :D
 

Users who are viewing this thread

Top Bottom