A
Ats
My main form has a datasheet subform. In the "On Current" event of the
subform, I have three controls on the main form populated by information
related to the active record in the subform -- a text box which takes the
value directly from a field in the subform and two list boxes which are
populated by SQL statements relating to a value in a subform field.
The text box works fine. However, changing the row source of a list box on
the main form causes the subform to jump back to the first record. This in
turn causes the Current event to fire again, and re-populates the main form
controls with info relating to the first record in the subform. I can change
other properties of the list box without this happening, but any time I
change the row source, it happens.
This does not happen in Access 2000 or 2003. The Current event of the
subform works as I intend in both of those version. It only happens in 2007.
Any thoughts?
subform, I have three controls on the main form populated by information
related to the active record in the subform -- a text box which takes the
value directly from a field in the subform and two list boxes which are
populated by SQL statements relating to a value in a subform field.
The text box works fine. However, changing the row source of a list box on
the main form causes the subform to jump back to the first record. This in
turn causes the Current event to fire again, and re-populates the main form
controls with info relating to the first record in the subform. I can change
other properties of the list box without this happening, but any time I
change the row source, it happens.
This does not happen in Access 2000 or 2003. The Current event of the
subform works as I intend in both of those version. It only happens in 2007.
Any thoughts?