Hi, I have an access db that may well need to be upsized to sql server. right now i am testing with the express edition.
i have a form with 2 subforms. one subform shows a summary of the records for this mainform, the other subform shows related summary information. when you click a line of the 2nd subform, the form with the full record opens just fine. when you click on a record in the first subform i want it to change the current record in the mainform to the one selected in the subform. i found or someone helped me with this many moons ago to get this solution:
this works great in access, but in testing in the upsized environment, it crashes with the following error:
"Object doesn't support this property or method"
and the highlighted code from the debuggger is the line Me.Parent.RecordsetClone.FindFirst. i think this is because this is DAO and i need to convert it to ADO, but i have no clue on how to do it. i would appreciate any guidance into how to pull this off.
thanks
"Maturity is a bitter disappointment for which no remedy exists, unless laughter can be said to remedy anything."
-Vonnegut
i have a form with 2 subforms. one subform shows a summary of the records for this mainform, the other subform shows related summary information. when you click a line of the 2nd subform, the form with the full record opens just fine. when you click on a record in the first subform i want it to change the current record in the mainform to the one selected in the subform. i found or someone helped me with this many moons ago to get this solution:
Code:
Private Sub txtEvalDate_DblClick(Cancel As Integer)
If Me.Parent.Tag = "Outcomes" Then
Me.Parent.RecordsetClone.FindFirst "[EvalDate] = #" & Me![txtEvalDate] & "#"
Me.Parent.Bookmark = Me.Parent.RecordsetClone.Bookmark
Else
DoCmd.OpenForm "frmSAOutcomes New forms layout", , , "[SSN] = '" & Me.txtSSN & "' AND [EvalDate] = #" & Me.txtEvalDate & "#", acFormEdit
End If
End Sub
"Object doesn't support this property or method"
and the highlighted code from the debuggger is the line Me.Parent.RecordsetClone.FindFirst. i think this is because this is DAO and i need to convert it to ADO, but i have no clue on how to do it. i would appreciate any guidance into how to pull this off.
thanks
"Maturity is a bitter disappointment for which no remedy exists, unless laughter can be said to remedy anything."
-Vonnegut