Form OnCurrent and subform - problem

  • Thread starter Thread starter Piers 2k
  • Start date Start date
P

Piers 2k

Hi folks,

Have form which contains code under the OnCurrent event: If a value in a
field is less than zero, make label font red. Works fine.

However, this form is a subform with Continuous view.
I set the subform size to only view 1 record at a time.

If I scroll the subform, the OnCurrent event doesn't kick in until I click
on the form, which appears incorrect on other records until I clikc on that
record in that form.

Is it possible to force the OnCurrent event to fire when the 'view' is
changed, not the active record?

TIA,
Piers
 
Change the subform fron continus form to single form, let the user navigate
between records using the navigate button instead of the scroll bar, that
will activate the on current event.
 
Back
Top