Solved

AfterUpdate event

Posted on 2007-04-04
7
367 Views
Last Modified: 2007-04-04
I have a subform viewed as a continuous form. I'm trying to do something simple but its not coming out correct. I have a double click event in my txtPN, a popup form comes up and the user double clicks on a Part number, item goes into my txtPN.  how do I do an Afterupdate and automatically have the cursur go to my next textbox of  txtQTY.  
0
Comment
Question by:goingolfn99
7 Comments
 
LVL 15

Assisted Solution

by:jmantha709
jmantha709 earned 100 total points
ID: 18853496
What do you have so far ?

Did you try :

txtQTY.SetFocus
0
 
LVL 61

Accepted Solution

by:
mbizup earned 200 total points
ID: 18853511
When you open the popup for in the double-click event, open it as acdialog, so that the code will resume when the popup closes... something like this:

Private Sub txtPN_DoubleClick()
   Docmd.openform "Yourpopupformname",,,,,acdialog  '*** check the number of commas here (aircode)
   me.txtQty.setfocus         '** go to next textbox
end sub
0
 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 200 total points
ID: 18853529
In you popup routine:

Me.txtPN.Text = <the part number>
Me.txtQTY.SetFocus

mx
0
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 

Author Comment

by:goingolfn99
ID: 18853582
Thanks guys
0
 
LVL 61

Expert Comment

by:mbizup
ID: 18853596
Glad to help :)
0
 
LVL 75
ID: 18853611
and Girls :-)

mx
0
 
LVL 61

Expert Comment

by:mbizup
ID: 18853618
thx, mx :-)
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

680 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question