View Single Post
  #1  
Old June 2nd, 2010, 06:45 PM posted to microsoft.public.access.forms
laeldo
external usenet poster
 
Posts: 6
Default 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!