Forms: Survey database

[cpidgeon]

Hello,

I have a 38 question survey that was originally designed on paper.
I was asked to setup the survey as a database. (one questions per form = 38 forms)The paper document has skip logic-- So, it banches to the next question, based on the users answers. Can anyone offer any advice?

 

[GraemeG]

Hello,

I have a 38 question survey that was originally designed on paper.
I was asked to setup the survey as a database. (one questions per form = 38 forms)The paper document has skip logic-- So, it banches to the next question, based on the users answers. Can anyone offer any advice?

Hi,
from what you are asking I think the setfocus after update would suffice.
I.e
Private Sub "name of current txt/combo box"_AfterUpdate()
Me."name of txt/combo box to move to after answered".SetFocus
End Sub

 

[cpidgeon]

Hi,
from what you are asking I think the setfocus after update would suffice.
I.e
Private Sub "name of current txt/combo box"_AfterUpdate()
Me."name of txt/combo box to move to after answered".SetFocus
End Sub

I could not get this to work. Can you take a look at my code?

Private Sub Ctl1a_AfterUpdate()
Me.PQL1b_1e.SetFocus
End Sub

Private Sub Ctl1a_BeforeUpdate(Cancel As Integer)
If Ctl1a = Yes Then
Me.PQL1b_1e.Visible = True
Me.PQL1g.Visible = False
Else

If Ctl1a = No Then
Me.PQL1g.Visible = True
Me.PQL1b_1e.Visible = False
End If
End If
End Sub