More then one IIF statement on a text box

[McRoberts]

I have a form for client satisfaction surveys.
When an information call comes in it is logged in the form and we ask if we have consent to do a questionnaire. In my "On Current" Event of my main form and the "After Update" event of the Consent Obtained combo I have the following code:

If Me.txtConsentObtained = "Yes" Then
Me.Status = "OPEN"
Else
Me.Status = "CLOSED"
End If
End Sub

That works fine.... My question is...

Now if they give consent then the a staff member will call the client back about a week later. If they return the call then Status remains open. If they do not return the call then I have a combo box (yes or no) "Returned Call" that the staff changes to No. I want the Status to change to CLOSED if Returned Call = No. If returned call is Yes then I want the Status to remain as OPEN.

Then if they return the call, the staff asks if we can go through the survey questions. Again if I have a combo box "Survey Complete" and if they say No then I want the Status to change to CLOSED and if yes, I want the status to remain OPEN.

Then if they say yes to going through the survey questions the staff begin the survey. Once the survey is complete I have a Questionniare Complete check box. When staff check the box that the survey is complete I want the Status to change to CLOSED.

I am new to Access and can't figure out the coding that needs to occur to make this happen without giving me an error on my form or dirtying a record when I just open the form to add a new record. I have tried putting the same code as above on the After Update of the other combo boxes but it seems to dirty a record when I open the form to log a call and it won't let me add it to the On Current of the subforms.

I appreciate any help given.

 

[KenHigg]

This is a little confusing...

1. Client calls and some infro is entered in db
2. Staff ask if they can do a survey
(Can't they perform the survey right then?...)
3. If no then the record is closed, if yes, the record remains open.
4. A week later, staff calls client to do survey...
5. After survey, record is closed


What's next?

 

[McRoberts]

1. Client calls and some infro is entered in db
2. Staff ask if they can do a survey
(Can't they perform the survey right then?...) No we need to give them time to see if the information that we provided was useful/valuable - approx. one week
3. If no then the record is closed, if yes, the record remains open.
4. A week later, staff calls client to do survey
5. If staff are not able to reach the client then after one week the record is closed, if yes (they are able to reach the client) the record remains open
6. Staff asks client if they will participate in the survey at this time - if no then closed, if yes then remain open
7. Staff conducts survey and once survey is complete checks Questionnaire Complete and status will then be closed.