Populate field based on multiple selection in multiple fields

[wpshop]

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.

 

[alborg]

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

 

[Doug Robbins - Word MVP]

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]

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.

 

[wpshop]

A table in access.

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

 

[alborg]

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

 

[Doug Robbins - Word MVP]

And how is the data arranged in that table?

--
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