requery result

[hughess7]

Hi all

I have a subform where Issue codes are selected by the user, each issue code
has a level result. The highest level is always displayed on the Main Form
for reference in an unbound control. It uses a dlookup statement to get the
highest result for the claim record displayed on screen. I have this result
being refreshed if a new issue code is chosen by the user on the subform
(tied to the after update event of the subform - for some reason afterupdate
event of the actual issue code field on the subform would not work?). It does
work, but is a little slow and refreshes the subform aswell which is odd - in
that the record selector moves to the first issue code in the list rather
than the record the user clicked in?

But I also want it to refresh if an Issue is deleted from the subform -
which it doesn't do. It will refresh if a new code is entered, or one
altered, but not if one is deleted. is there a better way to achieve this
please?

Thanks in advance for any help.
Sue

 

[hughess7]

Thanks Ken but this produces exactly the same result? Requeries the level on
main form but cursor still goes to first record on subform and it doesn't
recalc if a record is deleted from subform either...

Thanks
Sue