Refresh list box on page up/down

[sharontodd]

I have a list box which is updated via a control source which gets typed in.
I would also like it to update if the user presses page up/down. Can I put a
refresh somewhere in a form event to make that happen?

 

[Alex Dybenko]

Hi,
what happens when you press page up/down? If you list records - then you can
use Current event

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[sharontodd]

Have that. Found another problem too.

These are the fields on the form

Enter_data - text box - User types in the division they want to view
Show division - List box - Table =Division Winners. Updates based on what is
typed in control source Enter_data. Includes Div #.
First - Text box - Table =Division Winners. Is to show Reg # of whom won
first in division selected above. Control Source Div #.
First_data - List box - Table =Registrations. Shows remaining info for
whomever got first place. Control Source First.

Show_Division updates fine when typing in Enter_data but does nothing when
paging up/down.
First updates but it is not showing the division selected. It is just going
up a record every time I press enter or page up/down. So, the Show_division
and the winner being shown is not from the same record.

I would really apprieciate any help. I am rather new to Access and am
learning lots but have a long way to go.

THanks
sharontodd