If yes, selected do this

  • Thread starter Thread starter Paula
  • Start date Start date
P

Paula

I'm trying to create a database and I'm not sure where to go with it. I have
several yes/no questions to ask. If the user selects yes, I want it to pop
up another question and store the answer in a table. If the users selects
no, I want it to go to the next field on the form. Any ideas?
 
Paula

It isn't clear from your description whether you are trying to control the
flow or trying to present questions, as in a survey, ... or maybe both!

If you'll provide a bit more specific description of "what" you want to
accomplish, rather than "how", folks here may be able to offer more specific
suggestions.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
I am in the beginning stages of creating the database, so I'm doing the data
model now. Basically a patient will come in and a nurse will ask several
questions. I have a total of 39 questions. If they say yes to Q1, they need
to be asked Q2, Q3 and Q4. If they answer no, it will need to skip to Q5 and
so on throught the questions. I'm not sure if I should use option groups,
the standard yes/no set up or a custom yes/no because I'm not sure how to
handle. I have a lot of experience in Access, but have never had to do more
then standard forms etc. So please consider me a beginner.
 
Back
Top