On Current Event displays the previous record instead of the record pointed to

[matthewemiclea]

I have a subform, where in the "on current" event, I display code that
is supposed to recognize which record I am pointing to, and then
display more specific info in another subform based on that one record
that I have highlighted.

Example.... you point to ID Number: 1111 in the top subform.... all
specific info for ID Number: 1111 will then display in the second
subform.

My problem is: The second subform is actually displaying the specific
information for the previous record that I was pointing to rather than
the current one.

Example... I first point to ID Number: 1111, nothing shows up in the
other subform.... I then point to ID Number: 2222 and the specific
information for ID Number 1111 is displayed.

This is a huge problem because my employees are pointing to an ID
number and think they are looking at the right specific info, when they
are actually making decisions based on other ID's.

ANY ideas on how to correct this would be appreciated.

Thanks,

matt

[Scott McDaniel]

Post the code you're using to synchronize your subforms.

<ma************@eaton.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...

I have a subform, where in the "on current" event, I display code that
is supposed to recognize which record I am pointing to, and then
display more specific info in another subform based on that one record
that I have highlighted.

Example.... you point to ID Number: 1111 in the top subform.... all
specific info for ID Number: 1111 will then display in the second
subform.

My problem is: The second subform is actually displaying the specific
information for the previous record that I was pointing to rather than
the current one.

Example... I first point to ID Number: 1111, nothing shows up in the
other subform.... I then point to ID Number: 2222 and the specific
information for ID Number 1111 is displayed.

This is a huge problem because my employees are pointing to an ID
number and think they are looking at the right specific info, when they
are actually making decisions based on other ID's.

ANY ideas on how to correct this would be appreciated.

Thanks,

matt