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" wrote in
message .. .
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" wrote in message
...-
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