requery result

  • Thread starter Thread starter hughess7
  • Start date Start date
H

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
 
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
 
Back
Top