Refresh list box on page up/down

  • Thread starter Thread starter sharontodd
  • Start date Start date
S

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?
 
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
 
Back
Top