SelectionChange Event

[Max Moor]

Hi All,
I want to trigger an event procedure to run each time a user selects
a different record on a subform. The subform is just a plain "Continuous
Forms" view thing. I understand OnSelectionChange only works for pivot
tables. (It's not working for me on this, at least) Can anyone give me
some ideas?

- Max

 

[Van T. Dinh]

Try the Form_Current Event of the Form being used as the
SourceObject of the Subform Control.

HTH
Van T. Dinh
MVP (Access)

 

[Wayne Morgan]

The Form's OnCurrent event fires each time you go from one record to
another, including going to the first record as the form opens.

 

[Max Moor]

The Form's OnCurrent event fires each time you go from one record to
another, including going to the first record as the form opens.

Thanks Wayne and Van. That was just what I needed.

- Max