 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / May 2008make a form pause for user to select from drop down list.
I'm building data for a report and after the data is built I prompt the user as to how they want the data to be displayed, they can display by individual or by a category, if they select by Individual I make visible the combo box where they can select the individual the problem I'm having is that even though I set the focus to the combo box the program just continues on without any pause. I need the program to pause on the combo box so the user can select the individual and I will have the emp# to lookup by. Does anybody have an answer. Thanks for any help. Howdy, CD Saw you making smoke on the cover of The Cowby Chronicle. The only way to pause code is to open a form in dialog mode Docmd.OpenForm "SomeForm", , , , , acDialog It will pause until the form closes. You may need to consider using this approach and passing the value back to the other form when the dialog form closes.  SignatureDave Hargis, Microsoft Access MVP > I'm building data for a report and after the data is built I prompt the user > as to how they want the data to be displayed, they can display by individual [quoted text clipped - 4 lines] > select the individual and I will have the emp# to lookup by. Does anybody > have an answer. Thanks for any help. Oh how do you pass that information back? > Howdy, CD > Saw you making smoke on the cover of The Cowby Chronicle. [quoted text clipped - 14 lines] > > select the individual and I will have the emp# to lookup by. Does anybody > > have an answer. Thanks for any help. Quite a surprise, I helped them do the scoring. Are you still active in Cowboy action? I thought that was going to be the only way, isn't there a pause command that I could put after the dialog box and then in the after update make it continue? > Howdy, CD > Saw you making smoke on the cover of The Cowby Chronicle. [quoted text clipped - 14 lines] > > select the individual and I will have the emp# to lookup by. Does anybody > > have an answer. Thanks for any help. Is there anyway to position the dialog form in a particular spot on the screen? > Howdy, CD > Saw you making smoke on the cover of The Cowby Chronicle. [quoted text clipped - 14 lines] > > select the individual and I will have the emp# to lookup by. Does anybody > > have an answer. Thanks for any help. Yep, I was out shooting Saturday. You can pass the value back to the calling form by pushing the value to it. I would use the dialog form's Unload event. Assume it has a combo on it and you are passing it back to a combo on the calling form: Forms!CallingFormName!cboSomething = Me.MyCombo As to positioning, you could use the MoveSize method in the dialog form's Load event. SignatureDave Hargis, Microsoft Access MVP > Is there anyway to position the dialog form in a particular spot on the screen? > [quoted text clipped - 16 lines] > > > select the individual and I will have the emp# to lookup by. Does anybody > > > have an answer. Thanks for any help. |
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.