save record without leaving the record

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy previous record into form field 0
Populate main form from subform record 0
Event for Form on a tab control: Force User to Click Save button 7
DMax on existing record to increment serialized # fails 1
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Combo box refresh with limit to list = no 0
refresh/requery subform 2
Highlight a selected record 2

Top