|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
|
When I run, or I should say, try to run, the following, I get a type mismatch error on the line:
Set rst = Me.RecordsetClone This is very puzzling since it is copied almost verbatim from the help files, and I have done this sort of thing before. There is something I am just not seeing! Any help would be greatly appreciated! (If there is anything else wrong, well I havn't had a chance to get that far yet!) Thanx, -plh Private Sub cmdCloseAndPassValue_Click() On Error GoTo Err_cmdCloseAndPassValue_Click Dim rst As Recordset Set rst = Me.RecordsetClone Set varBookmark = rst.Bookmark 'rs = Nothing DoCmd.OpenForm "frmToolAssems", acNormal, , , , , OpenArgs & ";" & txtCurrTool.Value DoCmd.Close acForm, "frmTools" Exit_cmdCloseAndPassValue_Click: Exit Sub Err_cmdCloseAndPassValue_Click: MsgBox Err.Description Resume Exit_cmdCloseAndPassValue_Click End Sub |
|
#2
|
|||
|
|||
|
Not seeing your complete code try this
Dim rst As Object See if this corrects the problem lwells |
|
#3
|
|||
|
|||
|
Thanks for the suggestion, but it turns out I did not have DAO loaded, only ADO when I loaded DAO and gave it a higher priority than ADO (not sure if this latter step was actually necessary) the problem went away.
-plh |
![]() |
| Viewing: Dev Articles Community Forums > Databases > Microsoft Access Development > RecorsetClone Mystery |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|