 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms Programming / June 2006Refresh - Requerry - Update?
I have a from that uses two tables what I need is once you enter the employee # in to the first column it should update the next 3 fields with the related info from the main table...example Table 1 has and Table 2 has Emp# Emp # (this is the relationship) N_Title Name N_Date Title N_Office Office What I want is to be able to do is type in the Emp # hit tab and it pull the Name, Title and Office from the related table I would then be able to enter the New Title, Office and Date of the change. OK...Figured this out...however what I did was Requerry which jumps my cursor up to the first box in the form...is there anyway to make it goto the N_Title for the record I am on after the requerry? > I have a from that uses two tables what I need is once you enter the employee > # in to the first column it should update the next 3 fields with the related [quoted text clipped - 9 lines] > the New Title, Office and Date of the change. > After your rrequery statement, set the focus to whichever control on the form your wish.....Anycontrol.Setfocus > OK...Figured this out...however what I did was Requerry which jumps my cursor > up to the first box in the form...is there anyway to make it goto the N_Title [quoted text clipped - 13 lines] > > the New Title, Office and Date of the change. > > I used an on Entry Macro to get my results how would I add this to that or would I need to make it code. > After your rrequery statement, set the focus to whichever control on the form > your wish.....Anycontrol.Setfocus [quoted text clipped - 16 lines] > > > the New Title, Office and Date of the change. > > > If you are using a macro, you will need to add a line after your requery statement in the Macro window. I think the Action is GoToControl. At the bottom of the window you can list the Control name. Let me know if this post helps. -Toco- > I used an on Entry Macro to get my results how would I add this to that or > would I need to make it code. [quoted text clipped - 19 lines] > > > > the New Title, Office and Date of the change. > > > > That worked however I now enter the # hit tab it fill it in then I move to the next line to enter the next # after I hit tab it moves to the first line again. Any idea on how to fix that. > If you are using a macro, you will need to add a line after your requery > statement in the Macro window. I think the Action is GoToControl. At the [quoted text clipped - 26 lines] > > > > > the New Title, Office and Date of the change. > > > > > It's probably best to set the tabbing order. Tab order can be set on the form. If you right click the box that is left of the label that says 'Detai' (with an arrow pointing down), you will see Tab Order. This may eliminate the extra macro you wrote--the one about setting the focus > That worked however I now enter the # hit tab it fill it in then I move to > the next line to enter the next # after I hit tab it moves to the first line [quoted text clipped - 30 lines] > > > > > > the New Title, Office and Date of the change. > > > > > > |
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.