[AccessD] Trigger An Event by Changing Records in aContinuous Form?

Dan,

    Pending a direct solution on the lines sought in your post, you can consider a proactive approach. This would involve measures like removal of scroll bars, disabling of mouse scroll wheel, disabling of PgUp and PgDn keys.

    Instead, navigation would be totally controlled by command buttons (suitable command buttons for PgUp and PgDn can be added if desired). That way, the current record should never go out of view.

Best wishes,
A.D. Tejpal
------------

  ----- Original Message ----- 
  From: Dan Waters 
  To: 'Access Developers discussion and problem solving' 
  Sent: Saturday, September 13, 2008 06:14
  Subject: Re: [AccessD] Trigger An Event by Changing Records in aContinuous Form?


  The continuous form only shows one record at a time, and the formatting for
  the controls gets fairly complex.  I'd like to avoid putting complicated
  text into conditional formatting fields, but instead trigger a reformat in
  code each time a different record is displayed.

  Conditional formatting will work here, but it's really time consuming and it
  has no compiler or run-time errors, so anything wrong will go undetected
  until try all your examples and just look at the screen.

  Dan

  -----Original Message-----
  From: accessd-bounces at databaseadvisors.com
  [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
  Sent: Friday, September 12, 2008 7:17 PM
  To: Access Developers discussion and problem solving
  Subject: Re: [AccessD] Trigger An Event by Changing Records in a Continuous
  Form?

  The OnCurrent event is triggered automatically when you move to another
  record.  However, the scrollbar/mousewheel/pgdwn/pgup only affects the
  display, not the selected record, so it doesn't trigger OnCurrent.  Can
  you explain more about what you're trying to do?

  Charltote Foust 

  -----Original Message-----
  From: accessd-bounces at databaseadvisors.com
  [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
  Sent: Friday, September 12, 2008 4:02 PM
  To: 'Access Developers discussion and problem solving'
  Subject: [AccessD] Trigger An Event by Changing Records in a Continuous
  Form?

  On a continuous subform, I would like to trigger an event when a
  different record is viewed, either because the mouse wheel was used or
  because the scrollbar was used.

  Is there a way to do this?  Somewhere an event is being triggered
  because conditional formatting will be used to reformat comboboxes and
  textboxes.

  Thanks!
  Dan