As Larry said, exactly what you want to do cannot be done within Access
requirements, but there are other ways to get the same functionality:
instead of using a listbox, consider using a continuous form
(I have some really neat code to highlight the active record if you want it)
if you want to keep using the listbox, the only way to trap the
movements is to control them... lock the listbox and force the users to
scroll using command buttons for (ie
UP, DOWN, TOP, BOTTOM, and
possibly also a Search combo...
(: have an awesome day
(: have an awesome day
Larry Linson wrote:
> There's no event triggered by scrolling in a continuous forms view Form
> (whether or not it is embedded in a Subform Control). The OnCurrent event
> fires when you select a different record, but simply scrolling does not
> select a different record (as you see if you left the RecordSelector active
> in that Form).
> Very likely, you found an ActiveX control that provides the capability you
> want. But, unless it specifically says it is created and tested to be used
> with Access, it may not work -- not nearly all ActiveX controls meet Access'
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13711-which-event-is-triggered.html
> Sorry I don't have better news.
> Larry Linson
> Microsoft Access MVP
> "Gino" wrote in message
>>I needed a very simple listbox with check mark for each record, (which is
>>available within Access), so I created a simple subform with one text
>>and the checkbox, which I use in a way similar to a listbox (i.e. when I
>>click on a record in my subform, the main form displays that record).
>>This is triggered by a Click_Event on the text field on the subform and it
>>However, I need to be able to scroll up and down the subform using the
>>keys and have the main form synch with the subform.
>>I do not seem to find an event which gets triggered by simply moving to
>>the next or previous record using arrow keys or the navigation buttons at
>>bottom of the subform (I tried OnChange, OnCurrent, BeforeUpdate and
>>AfterUpdate etc. etc., but since there is no actual data change nothing
>>Thank you very much.
>>P.S. I found a clever free utility which displays listboxes with check
>>The demo works fine but it requred a bit too much knowledge for me to
>>customise it to my requirements. (I can't remember the link to that site
>>I will post it if I find it).
>>When I click
>>it as a subform on a form using the same data.
>Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13711