Thank you Larry for the clarifications. This is what I suspected.
Regarding the Listbox with check marks" which I found on the web, it isReference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13711-which-event-is-triggered.html
actually coded in VBA and works with Access 97 and Access 2000. It does not
use an activex but some features within ACCWIZ.DLL which comes with a full
installation of Access.
The link with history and download is http://www.lebans.com/vb_listbox.htm
"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'
> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13711
> > available within Access), so I created a simple subform with one text
> > field
> > 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
> > works fine.
> > However, I need to be able to scroll up and down the subform using the
> > arrow
> > 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
> > the next or previous record using arrow keys or the navigation buttons at
> > the
> > bottom of the subform (I tried OnChange, OnCurrent, BeforeUpdate and
> > AfterUpdate etc. etc., but since there is no actual data change nothing
> > happens).
> > Any idea?
> > Thank you very much.
> > P.S. I found a clever free utility which displays listboxes with check
> > marks.
> > 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
> > but
> > I will post it if I find it).
> > When I click
> > it as a subform on a form using the same data.