If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
IF fields in forms - call up a FORMDROPDOWN list?
Hi,
Thanks to this board I managed to put IF statements into my form which autocompletes some questions based on the answers to earlier ones. However now I want to use the answer to an earlier question to call up a FORMDROPDOWN. For example if the user answers VW to a question that asks them what type of car they have, then a question which said what type of car? would appear with a dropdown list listing different types of VW cars. If they answered something else, then a different drop down list would appear. I can use IF statements like the following to autocomplete, but I can't seem to put a formdropdown list in there. Is this possible? This is what I have so far: What type of car? {FORMDROPDOWN} - this has the bookmark Car assigned by editing properties & contains a dropdown list of car makes The following is then autocompleted (depending on the answer to Car). Your contact person is {IF {Car} = "VW" "Janet" "Fred" } I can put a series of these IF statements together to get different contacts depending on the make. But I want to call up a FORMDROPDOWN in the IF statement, from which the user would then pick their car make. Thanks for any help I am using Word 2002 w/ XP professional. Juliet |
#2
|
|||
|
|||
Take a look at the following thread in Google between myself and a guy named
Phil. He wanted to do the same sort of thing: http://groups.google.com/groups?hl=e...%2 6rnum%3D17 -- Please respond to the Newsgroup for the benefit of others who may be interested. Questions sent directly to me will only be answered on a paid consulting basis. Hope this helps, Doug Robbins - Word MVP "JKC" wrote in message ... Hi, Thanks to this board I managed to put IF statements into my form which autocompletes some questions based on the answers to earlier ones. However now I want to use the answer to an earlier question to call up a FORMDROPDOWN. For example if the user answers VW to a question that asks them what type of car they have, then a question which said what type of car? would appear with a dropdown list listing different types of VW cars. If they answered something else, then a different drop down list would appear. I can use IF statements like the following to autocomplete, but I can't seem to put a formdropdown list in there. Is this possible? This is what I have so far: What type of car? {FORMDROPDOWN} - this has the bookmark Car assigned by editing properties & contains a dropdown list of car makes The following is then autocompleted (depending on the answer to Car). Your contact person is {IF {Car} = "VW" "Janet" "Fred" } I can put a series of these IF statements together to get different contacts depending on the make. But I want to call up a FORMDROPDOWN in the IF statement, from which the user would then pick their car make. Thanks for any help I am using Word 2002 w/ XP professional. Juliet |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
in forms, my labels and fields are not visible, | AccessAmatuerAgain (AAA) | General Discussion | 1 | June 23rd, 2004 07:30 AM |
How do you format custom fields designed for custom contact forms? | Debalan | Contacts | 4 | May 19th, 2004 11:54 PM |
copying - drop-down list fields???? | plato | Setting up and Configuration | 1 | March 12th, 2004 06:16 PM |
Multiple List function | George | Worksheet Functions | 8 | February 15th, 2004 10:13 AM |