Populate field based on multiple selection in multiple fields wpshop 12/24/2008 4:35:01 PM I am fairly new to word as my previous company had a program to generate letters and forms and my new company does not. I have a form that is used when new business is generated. I need the commission to auto populate based on the broker and product selected (both drop down lists). There are too many combinations to use IF statements. Any assistance you can provide is greatly appreciated.

RE: Populate field based on multiple selection in multiple fields alborg 12/24/2008 9:55:01 PM Hi wpshop: If your dropdown combobox needs more than the limitation of 26 items, then you need to use a userform, check out Greg Maxey's discussion here- http://gregmaxey.mvps.org/FormField_UserForm_ListBox.htm I have a downloadable FMLA Word Template that I use at the office ("Family Medical Leave Act" form) which when clicked on, will automatically pop up 2 Userforms, one for patient name, and the other for physician information. Once you choose the appropriate patient/physician, the information gets populated onto your form. Since the physician list can be quite large, it is linked to a MS Access table. Note: the template comes zipped together with the tiny table. They both need to be in a folder together. Any Windows folder will do. URL: http://www.box.net/shared/static/yajuo2qu96.zip Cheers, Al "wpshop" wrote: [Quoted Text] > I am fairly new to word as my previous company had a program to generate > letters and forms and my new company does not. I have a form that is used > when new business is generated. I need the commission to auto populate based > on the broker and product selected (both drop down lists). There are too > many combinations to use IF statements. Any assistance you can provide is > greatly appreciated.

Re: Populate field based on multiple selection in multiple fields "Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 12/24/2008 9:59:57 PM And from where would the commission amounts/rate be obtained? -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "wpshop" <wpshop[ at ]discussions.microsoft.com> wrote in message news:0387160D-9DBC-44DA-BD4A-EE2BD990056E[ at ]microsoft.com... [Quoted Text] >I am fairly new to word as my previous company had a program to generate > letters and forms and my new company does not. I have a form that is > used > when new business is generated. I need the commission to auto populate > based > on the broker and product selected (both drop down lists). There are too > many combinations to use IF statements. Any assistance you can provide is > greatly appreciated.

RE: Populate field based on multiple selection in multiple fields wpshop 12/29/2008 6:38:02 PM Thank you! I am having one problem. The list is not displaying in my combobox. I see the prompt to open MS Access but when the form appears the drop down box has no values to choose from. I'm at a loss. "alborg" wrote: [Quoted Text] > Hi wpshop: > > If your dropdown combobox needs more than the limitation of 26 items, then > you need to use a userform, check out Greg Maxey's discussion here- > http://gregmaxey.mvps.org/FormField_UserForm_ListBox.htm I have a > downloadable FMLA Word Template that I use at the office ("Family Medical > Leave Act" form) which when clicked on, will automatically pop up 2 > Userforms, one for patient name, and the other for physician information. > Once you choose the appropriate patient/physician, the information gets > populated onto your form. Since the physician list can be quite large, it is > linked to a MS Access table. > > Note: the template comes zipped together with the tiny table. They both need > to be in a folder together. Any Windows folder will do. > > URL: http://www.box.net/shared/static/yajuo2qu96.zip > > Cheers, > Al > > "wpshop" wrote: > > > I am fairly new to word as my previous company had a program to generate > > letters and forms and my new company does not. I have a form that is used > > when new business is generated. I need the commission to auto populate based > > on the broker and product selected (both drop down lists). There are too > > many combinations to use IF statements. Any assistance you can provide is > > greatly appreciated.

Re: Populate field based on multiple selection in multiple fields wpshop 12/29/2008 8:58:03 PM A table in access. "Doug Robbins - Word MVP" wrote: [Quoted Text] > And from where would the commission amounts/rate be obtained? > > -- > Hope this helps. > > Please reply to the newsgroup unless you wish to avail yourself of my > services on a paid consulting basis. > > Doug Robbins - Word MVP > > "wpshop" <wpshop[ at ]discussions.microsoft.com> wrote in message > news:0387160D-9DBC-44DA-BD4A-EE2BD990056E[ at ]microsoft.com... > >I am fairly new to word as my previous company had a program to generate > > letters and forms and my new company does not. I have a form that is > > used > > when new business is generated. I need the commission to auto populate > > based > > on the broker and product selected (both drop down lists). There are too > > many combinations to use IF statements. Any assistance you can provide is > > greatly appreciated. > > >

RE: Populate field based on multiple selection in multiple fields alborg 12/30/2008 7:11:00 AM Hi wpshop: Are you talking about the FMLA form? If so, does it give you an error message? Most of the time it's due to a problem with an ActiveX control that did not sign on correctly. Go to the VB Editor, then do a Tools-> References and make sure that they are all OK. If it's your program, then you probably didn't link to the back-end tables twice, as described in my on-line tutorial here- http://www.msofficeemrproject.com/Book10.htm Notice that if successful, you need to see 2 instances of MSACCESS.EXE when you do a Ctrl+Alt+Del (see what's under the "Processes" tab). If that's not it, send it to me. My email is in the "Contact Me/About Me" webpage on that site. Cheers, Al "wpshop" wrote: [Quoted Text] > Thank you! I am having one problem. The list is not displaying in my > combobox. I see the prompt to open MS Access but when the form appears the > drop down box has no values to choose from. I'm at a loss. > > "alborg" wrote: > > > Hi wpshop: > > > > If your dropdown combobox needs more than the limitation of 26 items, then > > you need to use a userform, check out Greg Maxey's discussion here- > > http://gregmaxey.mvps.org/FormField_UserForm_ListBox.htm I have a > > downloadable FMLA Word Template that I use at the office ("Family Medical > > Leave Act" form) which when clicked on, will automatically pop up 2 > > Userforms, one for patient name, and the other for physician information. > > Once you choose the appropriate patient/physician, the information gets > > populated onto your form. Since the physician list can be quite large, it is > > linked to a MS Access table. > > > > Note: the template comes zipped together with the tiny table. They both need > > to be in a folder together. Any Windows folder will do. > > > > URL: http://www.box.net/shared/static/yajuo2qu96.zip > > > > Cheers, > > Al > > > > "wpshop" wrote: > > > > > I am fairly new to word as my previous company had a program to generate > > > letters and forms and my new company does not. I have a form that is used > > > when new business is generated. I need the commission to auto populate based > > > on the broker and product selected (both drop down lists). There are too > > > many combinations to use IF statements. Any assistance you can provide is > > > greatly appreciated.