IIF Function in Forms

[withk001]

Hi.

I am making a database, which will have a form as the front page and will be used by 2 members of staff. Ultimately it is a checklist/flowchart to ensure a process is being followed, and then record where the errors are occurring. So the top of the form will have basic information regarding this certain check (i.e. account number and staff member etc). Then there will be a checklist/flowchart, with questions that will have Yes/No answers.

I have previously made a similar database and form/checklist which was straight forward as the Yes/No answers would just lead to a pass or fail at the end. However, this particular process has a lot of 'If' statements meaning the next question to be answered will depend on the answer to this question. I.e. Q: "Is this an existing customer?"...The answer 'Yes' will need to bring up various questions, and the answer 'No' would need to bring up a different selection of questions?

Is there a function within Access that will allow us to do this?

I hope this makes sense, this is only my second database that I have built, so sorry if I have not been clear or more information is required



Thank you in advance.

Kirsty

[withk001]

After a bit more research am I right in thinking it would be a Conditional Visibility?

[pbaldy]

Well, conditional visibility can be done this way:

http://www.baldyweb.com/ConditionalVisibility.htm

Your situation may be more complicated, depending on your table structure. I've never done a survey/questionnaire sort of app, but others have recommended this as a starting place:

http://www.rogersaccesslibrary.com/f...ey_topic3.html

Not sure if it fits your situation though.

[JamesDeckert]

You could make questions visible/invisible based on answers, but this will get challenging if a yes needs two further questions and a no needs five (different number of additional questions). I'm assuming there is a list of many questions. If only a few, then no problem. Another alternative if formatting the form is a problem is to prompt the user for input with msgbox or inputbox based on the answers they are providing.

If you need more help, can you provide all the questions and the flow that should be followed? This will allow me go give more exact advice.