save record without leaving the record

  • Thread starter Thread starter tracey
  • Start date Start date
T

tracey

I have a form with several fields. I have written code to
execute on the AfterUpdate event of one field. the next
field (tab order) will receive the focus. The code is
updating other feilds on another form. I tried the recalc
method however it moved the focus to the first record on
the form, the requery does the same as well and also sorts
the form by records, I tried repaint and that doesn't seem
to work. I need to save the current record without
leaving the record, or leave the record and come back and
set focus to the next field (tab order). Any suggestions?

Thanks to all!
 
Back
Top