Solved

AfterUpdate event

Posted on 2007-04-04
7
339 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 - Access MVP)
DatabaseMX (Joe Anderson - Access MVP) earned 200 total points
ID: 18853529
In you popup routine:

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

mx
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 

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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

895 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now