Skip pattern based on text box value
in [Form]
|
From: laeldo on 2 Jun 2010 13:45 Hi, I have a text control. People will be typing either words or numbers into it. If they type 99 I want to skip down several questions. Here's the condition for my macro: [Forms]![frmFB213]![FB215]=99 The action is 'Go to control' and the control name points to question FB229. I've put my macro in the AfterUpdate section, but nothing is happening. I'm suspecting this is because the answer is free-text. All my skip patterns based on combo boxes are working well. I've tried putting single and double quotes around the 99, I've tried using the "Like" feature with 99 in and not in quotes. Can anyone tell me what I'm missing? Thanks so much!
From: Jeff Boyce on 2 Jun 2010 16:57 What is the data type of the field underlying that control on the form? Are you saying that you have one control per question? If so, what happens when you add/remove a question? Doesn't that require you to modify all your forms, queries, etc.? Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "laeldo" <laura.e.dodge(a)gmail.com> wrote in message news:788e67b4-f277-40a7-b7b0-5ab4bd2af8df(a)l6g2000vbo.googlegroups.com... > Hi, I have a text control. People will be typing either words or > numbers into it. If they type 99 I want to skip down several > questions. Here's the condition for my macro: > > [Forms]![frmFB213]![FB215]=99 > > The action is 'Go to control' and the control name points to question > FB229. I've put my macro in the AfterUpdate section, but nothing is > happening. I'm suspecting this is because the answer is free-text. All > my skip patterns based on combo boxes are working well. I've tried > putting single and double quotes around the 99, I've tried using the > "Like" feature with 99 in and not in quotes. Can anyone tell me what > I'm missing? Thanks so much! >
From: sandypeter111 on 3 Jun 2010 05:49 Jeff Boyce;3741109 Wrote: > What is the data type of the field underlying that control on the form? > > Are you saying that you have one control per question? If so, what > happens > when you add/remove a question? Doesn't that require you to modify all > your > forms, queries, etc.? > > Regards > > Jeff Boyce > Microsoft Access MVP > > -- > Disclaimer: This author may have received products and services > mentioned > in this post. Mention and/or description of a product or service herein > does not constitute endorsement thereof. > > Any code or pseudocode included in this post is offered "as is", with > no > guarantee as to suitability. > > You can thank the FTC of the USA for making this disclaimer > possible/necessary. > > "laeldo" laura.e.dodge(a)gmail.com wrote in message > news:788e67b4-f277-40a7-b7b0-5ab4bd2af8df(a)l6g2000vbo.googlegroups.com...- > Hi, I have a text control. People will be typing either words or > numbers into it. If they type 99 I want to skip down several > questions. Here's the condition for my macro: > > [Forms]![frmFB213]![FB215]=99 > > The action is 'Go to control' and the control name points to question > FB229. I've put my macro in the AfterUpdate section, but nothing is > happening. I'm suspecting this is because the answer is free-text. All > my skip patterns based on combo boxes are working well. I've tried > putting single and double quotes around the 99, I've tried using the > "Like" feature with 99 in and not in quotes. Can anyone tell me what > I'm missing? Thanks so much! > - The aim is to fix problems and all concerns as to who makes the hardware or software. Expect more. IT support Los Angeles and small business consulting offers premier small business computer consulting and managed IT services paired with easy access to computer sales and order management via online computer stores and help centers. ===================== *'Project Management Software' (http://www.project-drive.net/)* -- sandypeter111
From: laeldo on 3 Jun 2010 08:10 Hi Jeff, The data type under the control is Text. This project is for data entry for a large questionnaire. So each question on the questionnaire has a control on the form for an answer. If I need to add questions it doesn't screw up the numbers because they are already assigned on the paper questionnaire. If I need space for another answer because the respondent checked two boxes instead of just one, the question becomes 210a, 210b, etc. Is that what you're asking? Thanks!
From: Jeff Boyce on 3 Jun 2010 12:13 Not sure how this responds to the original poster's request... Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "sandypeter111" <sandypeter111.64d4198(a)officefrustration.com> wrote in message news:sandypeter111.64d4198(a)officefrustration.com... > > Jeff Boyce;3741109 Wrote: >> What is the data type of the field underlying that control on the form? >> >> Are you saying that you have one control per question? If so, what >> happens >> when you add/remove a question? Doesn't that require you to modify all >> your >> forms, queries, etc.? >> >> Regards >> >> Jeff Boyce >> Microsoft Access MVP >> >> -- >> Disclaimer: This author may have received products and services >> mentioned >> in this post. Mention and/or description of a product or service herein >> does not constitute endorsement thereof. >> >> Any code or pseudocode included in this post is offered "as is", with >> no >> guarantee as to suitability. >> >> You can thank the FTC of the USA for making this disclaimer >> possible/necessary. >> >> "laeldo" laura.e.dodge(a)gmail.com wrote in message >> news:788e67b4-f277-40a7-b7b0-5ab4bd2af8df(a)l6g2000vbo.googlegroups.com...- >> Hi, I have a text control. People will be typing either words or >> numbers into it. If they type 99 I want to skip down several >> questions. Here's the condition for my macro: >> >> [Forms]![frmFB213]![FB215]=99 >> >> The action is 'Go to control' and the control name points to question >> FB229. I've put my macro in the AfterUpdate section, but nothing is >> happening. I'm suspecting this is because the answer is free-text. All >> my skip patterns based on combo boxes are working well. I've tried >> putting single and double quotes around the 99, I've tried using the >> "Like" feature with 99 in and not in quotes. Can anyone tell me what >> I'm missing? Thanks so much! >> - > > The aim is to fix problems and all concerns as to who makes the hardware > or software. Expect more. IT support Los Angeles and small business > consulting offers premier small business computer consulting and managed > IT services paired with easy access to computer sales and order > management via online computer stores and help centers. > > ===================== > *'Project Management Software' (http://www.project-drive.net/)* > > > > > -- > sandypeter111
|
Next
|
Last
Pages: 1 2 Prev: Combo Box Adding Button to edit list items Next: Value list updates not appearing in form |