How to always set focus on the control on parent form after entering data in the subform (3 Viewers)

[Albert D. Kallal]

It will. The AfterUpdate will fire even if there's only one text box in a form. Give it a try.

I'm at work and haven't time to read all the rest of your reply. I'll check it during lunch time. Thanks for taking your time and replying.

Yes, you are correct!!!
(happy to be corrected on this issue == thanks for the follow up).

So, ignore my "narrative" on needing some extra textbox or control to receive the focus - not required.

So, good = don't try to use the UI for this - use recordset data processing.
So, bad = my bad is the part about needing that extra control? Nope - as noted, it's not required.....


R
Albert

 

[nector]

Many thanks to you all our valuable professionals we appreciate all your contribution and I'm glad that to say that through your help we managed to sort it out and its working ok.