I have a combobox and a textbox on a subform that both run VBA code after_update in which I have added a docmd.runmacro command that runs a macro that imports an excel spreadsheet. Before adding this command, I was able to enter data in these fields and tab to the next field. After adding this command, I've lost track of the cursor and must click the combobox or textbox and then tab or click the next entry box to continue entering data. This disrupts the data entry flow immensely. How do put the cursor back in the field using VBA code so that flow is not disrupted? I have tried using the .SetFocus and .SelStart=0 properties of the objects at the end of the after_update event of that, but the cursor is still in limbo. I tried adding a me.refresh and me.requery after the .SetFocus and .SelStart commands, but still no luck. I'm sure the answer is simple, but it is eluding me.
Thanks.