Recordsetclone error in listbox

[marjerie]

I have this statements if i run it error said
MS Access can't find the form!TimeCards

Private Sub cmdFind_Click()

Dim rst As DAO.Recordset

Set rst = Forms!fmrTimeCards.RecordsetClone

rst.FindFirst "TimeCardID = " & "'" & lstFind & "'"

Form!fmrTimeCards.Bookmark = rst.Bookmark

DoCmd.Close acForm, "frmFindTimeCards"

End Sub


I checked so many time for my form and it really same name
Hope can someone help me for this its make crazy..what's wrong on my statements

thank u in advance

 

[PHV]

Use the Form[!]s[/!] collection.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[TheAceMan1]

How are ya marjerie . . .

In your post origination you say:

[blue]I checked so many time for my form and it really same name[/blue]

. . . yet you have:

[blue]MS Access can't find the form![purple]TimeCards[/purple]
Set rst = Forms![purple]fmrTimeCards[/purple].RecordsetClone
DoCmd.Close acForm, "[purple]frmFindTimeCards[/purple]"[/blue]

Thats 3 different names! . . .

See Ya! . . . . . .

Be sure to see FAQ219-2884: