skip rules and tick marks

[mavergara]

have created a survey form and i want to know how will i create a skip rules with below question
1. May we know when did you last call our Hotline Service? if the answer is Others or Cant Recall, it will skip and go to the next segment question.

 

[GinaWhipp]

Without the actual database or it's structure, something like...

If Me.ControlName = "Others" OR "Cant Recall" Then
Me.GoToControl "ControlName"
End If

I am assuming that the Control you are going to is not in a continuous form.

 

[missinglinq]

And you'd want put Gina's code in ControlName_AfterUpdate(). AT the same time, you might want to Disable the 'skipped' Controls.

Linq ;0)>

 

[mavergara]

how will i disable the skip rules? thanks for your reply.

 

[mavergara]

Without the actual database or it's structure, something like...

If Me.ControlName = "Others" OR "Cant Recall" Then
Me.GoToControl "ControlName"
End If

I am assuming that the Control you are going to is not in a continuous form.

hi tried your suggestion but it seems not to work on my program. Also, another question, how will i link the other form since i have so many survey questions and the form can only holds up to 22 inches, thus i create another form for continuation. i wonder how will i link the two and also, how do i add another record for both form.

i attached a link for better appreciation. thanks!

 

[GinaWhipp]

Yep, that code would not work because you are using an Option Group. I have adjusted the code, so now it works to go to Q3. You can change that to go to any control you wish. (Sample attached)

To add the other form I would suggest you use a Tab Control. That way the two forms can be on one main page and your Users will just have to tab to the next form OR you can set it to do it automatically after completing the first part.

A few things I noticed...

You are using words *Reserved* by Access which will make certain things harder because Access may misinterpet what you meant. I am going to strongly suggest you amend those field names. For a complete list of Reserved Words see...

http://allenbrowne.com/AppIssueBadWord.html

I am also noticing that you are assuming that an Entity will only take the Survey once which may or may NOT hold true. For that reason I am suggesting you review this database for Data Model (or table set-up) suggestions...

Survey Database by Duane Hookom
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=3

My last suggestion would be to give the fields on the forms names that make sense. Frame126 doesn't tell you where or what that question is or where it is in the scope of things. For sample naming conventions have a look at...

http://www.granite.ab.ca/access/tablefieldnaming.htm

http://www.regina-whipp.com/index_files/NamingConventions.htm

 

[mavergara]

thanks to all of you! my survey is now working great. one last thing, how will I code if I want to always appear the agent name whenever a new record will make. thanks again.

 

[missinglinq]

... how will I code if I want to always appear the agent name whenever a new record will make.

Assuming that the agent's name is typed in when the first record is created, on opening the form, you can use the AfterUpdate event of the control holding your data to set the DefaultValue for the field. From that time forward, until you either manually change the data or close your form, the data will be entered automatically in each new record.

Private Sub AgentName_AfterUpdate()
   Me.AgentName.DefaultValue = """" & Me.AgentName.Value & """"
End Sub

You have to replace AgentName with the actual name of your Textbox, of course.

Linq ;0)>

 

[mavergara]

thanks so much i love you with all my heart

 

[missinglinq]

Glad we could help!

Linq ;0)>

 

[mavergara]

i definitely share this to novice like me who needs help...