 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / May 2007Pop up form meeting text box requierment
I want certain forms to pop up when certain words are entered into a sub form control text box. Example: Where the "Employee History" form has in the "situation" contorl text box the word from the list box "Accident", I want the "300 Form" to pop up and when that form is completed I want the 301 Form to pop up. All three table are linked in the Employee history table at the actionID control. Thanks in advance. You're going to have to trap the changes to the control(s) in question, evaluate them and then act accordingly. probably a case statement would work best Somthing like, StrCtlVal=Me.ControlName Select Case StrCtlVal Case "YourCriteria" docmd.openform "300 Form" Case "AnotherCriteria" docmd.openform "301"  SignatureHope this helps, Daniel P > I want certain forms to pop up when certain words are entered into a sub > form control text box. [quoted text clipped - 3 lines] > table are linked in the Employee history table at the actionID control. > Thanks in advance. Ok, where would I insert code? At the "Situation" control box? > You're going to have to trap the changes to the control(s) in question, > evaluate them and then act accordingly. probably a case statement would work [quoted text clipped - 17 lines] > > table are linked in the Employee history table at the actionID control. > > Thanks in advance. >I want certain forms to pop up when certain words are entered into a sub >form control text box. [quoted text clipped - 3 lines] >table are linked in the Employee history table at the actionID control. >Thanks in advance. Would it be satisfactory to have the 300 form pop up *after* the user has typed all the data into the textbox? I don't think you'ld want a textbox popping up while the user is busy typing - it might ACCIDENTally pop up when it needn't! If so, you can use the textbox's AfterUpdate event to check its value for the key words. I'm not sure what you mean by 'the word from the list box "Accident"' - is there a listbox named Accident? What "word" might it contain? Or are you looking for the word "accident" typed into the textbox? John W. Vinson [MVP] I see what you mean. The list box of the "Situation" has a number of word to select from and in that list words like "Vehicle injury accident" , "Animal injury attack" that would open or pop up the 300 form and then the 301 form while other words would not like safety review. I hope I have conveyed what I am needing. > >I want certain forms to pop up when certain words are entered into a sub > >form control text box. [quoted text clipped - 15 lines] > > John W. Vinson [MVP] >I see what you mean. The list box of the "Situation" has a number of word to >select from and in that list words like "Vehicle injury accident" , "Animal >injury attack" that would open or pop up the 300 form and then the 301 form >while other words would not like safety review. I hope I have conveyed what I >am needing. Not really. It sounded like you were having text typed freely into a textbox and needed to match it to values in a listbox. Apparently not. You can use the AfterUpdate event of the listbox to determine which value was selected, and then open a form based on the value. But it's not clear from this WHICH values would cause this other form to open - and I'm really queasy about embedding the business logic in the name values anyway! I'd be inclined to add another field to the Listbox's RowSource table indicating which supplementary form should be opened (maybe someday there will be one form for accidents, a different form for other medical emergencies, ...), rather than trying to parse the actual text value from the listbox. Would that be a reasonable approach? John W. Vinson [MVP] |
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
|
©2009 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.