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
|
|||
|
|||
Skip pattern based on text box value
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! |
Thread Tools | |
Display Modes | |
|
|