Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Modules / DAO / VBA / May 2008

Tip: Looking for answers? Try searching our database.

Refresh list box on page up/down

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
sharontodd - 22 May 2008 03:53 GMT
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 - 22 May 2008 10:46 GMT
Hi,
what happens when you press page up/down? If you list records - then you can
use Current event

Signature

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

>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?
sharontodd - 22 May 2008 13:24 GMT
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

> Hi,
> what happens when you press page up/down? If you list records - then you can
[quoted text clipped - 5 lines]
> > put a
> > refresh somewhere in a form event to make that happen?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.