 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / May 2007Tabing from one subform to another
I have created a macro that will allow the user to move from one subform to the next subform both are within a main form. The marro works great, except when tabing from the last field in the first subform to the first field in the second subform the first subform apears to go blank. I know the data is still within the table, after testing, but this is the type of thing that will drive my users nuts. What am I doing wrong or is there a setting I am missing? Thanks for the help  SignatureJacqueline Hi Jacqueline , perhaps that is because you are tabbing to a new record... set the form Cycle property (Other tab) to --> Current Record Warm Regards, Crystal * (: have an awesome day :) * MVP Access Remote Programming and Training strive4peace2006 at yahoo.com * > I have created a macro that will allow the user to move from one subform to > the next subform both are within a main form. The marro works great, except [quoted text clipped - 6 lines] > > Thanks for the help Awsome! that worked thanks so much SignatureJacqueline > Hi Jacqueline , > [quoted text clipped - 22 lines] > > > > Thanks for the help you're welcome, Jacqueline ;) happy to help Warm Regards, Crystal * (: have an awesome day :) * MVP Access Remote Programming and Training strive4peace2006 at yahoo.com * > Awsome! that worked thanks so much Hi Jacqueline Would you mind tell me how did you created a macro that allow user to move from one subform to the next subform? Thank you very much Hong > you're welcome, Jacqueline ;) happy to help > [quoted text clipped - 9 lines] > > > Awsome! that worked thanks so much Hello Hong, in the code behind the first subform: Me.Parent.subform2.SetFocus Me.Parent.subform2.Form.controlname2.SetFocus Warm Regards, Crystal * (: have an awesome day :) * MVP Access Remote Programming and Training strive4peace2006 at yahoo.com * > Hi Jacqueline > [quoted text clipped - 17 lines] >> >>> Awsome! that worked thanks so much Thanks > Hello Hong, > [quoted text clipped - 34 lines] > >> > >>> Awsome! that worked thanks so much you're welcome, Hong ;) happy to help Warm Regards, Crystal * (: have an awesome day :) * MVP Access Remote Programming and Training strive4peace2006 at yahoo.com * > Thanks > [quoted text clipped - 36 lines] >>>> >>>>> Awsome! that worked thanks so much |
Reply to this Message |
 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.