troubleshooting Question

Why having to press tab key twice?

Avatar of SteveL13
SteveL13Flag for United States of America asked on
Microsoft Access
4 Comments1 Solution157 ViewsLast Modified:
I have the following code in an AfterUpdate event of a number field on a subform.  But after making an entry in the field I have to press the tab key twice to go to the next field as determined by the Tab Index.  Why would this be happening?  I really only want to tab one time.

Note: There is a field on the parent form that is being recalculated as the entry has been made in the subform field, hence the Me.Parent.Refresh code line.

    Me.txtProduct1StockAddedValue = Nz(DLookup("[StockAddedValue]", "tblProducts", "[ProductID] = 12"), 0) * Me.txtProduct1
    If IsNull(Me.txtProduct1) Then Me.txtProduct1StockAddedValue = 0
    Me.Parent.Refresh

Open in new window

ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros