Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 1 / August 2005

Tip: Looking for answers? Try searching our database.

subform question

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
js - 31 Aug 2005 14:56 GMT
need help going from one txtbox in one subform to another textbox in
another subform

so i have

main frm -inside there are: subfrm1 (textboxes: a1 a2 a3 ) and subfrm2
(b1 b2 b3)

how do i go from txtbox a2 to b2 -- if a condition is met at a2?

Thanks in advance for your help

j
MGFoster - 31 Aug 2005 20:49 GMT
> need help going from one txtbox in one subform to another textbox in
> another subform
[quoted text clipped - 7 lines]
>
> Thanks in advance for your help

In the AfterUpdate Event Procedure of the a2 TextBox:

Parent!subfrm1.SetFocus
Parent!subfrm1.Form!b2.SetFocus

In the past (Access version 97) I found that I had to set the focus on
the subform control first and then set focus on the control in that
subform.  Trying to directly set the focus on a control in the other
subform in one command just didn't work; therefore, 2 commands.
Signature

MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

js - 31 Aug 2005 21:23 GMT
thanks for responding - I tried but it did not worked.

i have a parent form very much like the [customer orders] in Northwind
and I also have the equivalent to

[customer orders subform1] and [customer orders subform2]

I will like to jump from [customer orders subform1] to
[customer orders subform2] if one of the textboxes in [customer orders
subform1] meets a criteria

i am also working with acc2003

thanks
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.