I am having a strange bookmark problem. I have a main form called
frmSurveyQSubQ. This form has a subform called sfrmRespodent.
SfrmRespondent has a sfrm in it called sfrsfrmResponse s.
I have a list box on main form called lstQuestion that displays all the
questions relevant to a survey. Clicking on a question in it fills the
second list box "lstSuquest ion" with relevant sub questions for
selected question in lstQuestion on main form. The code I am using is
Private Sub lstQuestion_Aft erUpdate()
Me![lstSubQuestion].Requery
Dim rs As Object
Set rs = Me.Recordset.Cl one
rs.FindFirst "[QuestionID] = " & str(Me![lstQuestion])
Me.Bookmark = rs.Bookmark
'Reset the combo box.
Me.lstQuestion = ""
End Sub
From the filled listSubquestion I click on a subquestion that fills the
relevant Respondent in lstRespondent list box for selected subquestion.
Private Sub lstSubQuestion_ Click()
Dim rs As Object
Set rs = Me.Recordset.Cl one
rs.FindFirst "[SubQuestionID] = " & str(Me![lstSubQuestion])
Me.Bookmark = rs.Bookmark
'Reset the combo box.
Me.lstSubQuesti on = ""
Me.cmdAddImpact .Enabled = True
End Sub
Every thing is working fine. I select Question "QuestionA" , that is
associated with SubQuestion "SubQuesA", SubQuesB" etc. Selecting one of
the selected subquestion shows me the correct Respondent assocaited
with it.
The problem occurs when I select Question "QuestionB" which is also
associated with "SubQuesA", Selecting on SubquesA takes me back to
QuestionA instead of showing me associated Respondent for Question B
and SubQuestA.
In other words if a sub question is associated with more than one
question, selecting on that sub question takes me back to the
associated previously opened question not the current question for
which the sub question is selected for.
No matter how much I try I can not view Respondent associated with
QuestionB and SubQuesA. It keeps on taking me back to Question A and
sub QuestionA.
Any help would be appreciated.
MK
