RecordsetClone not workin

G

Guest

I used the thread LISTBOX AFTERUPDATE 5/24/06 unfortuately still not workin
I have this error

"MS Office Access cant find the form 'frmTimeCards' referred to in a macro
expression or VBcode"

the I checked the formname and its correct I don't kniow why there's an error
Please help thanks much

This my coding

Private Sub cmdFind_Click()

Dim rst As DAO.Recordset

Set rst = Form!frmTimeCards.RecordsetClone

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

Form!frmTimeCards.Bookmark = rst.Bookmark

DoCmd.Close acForm, "frmFindTimeCards"

End Sub
 
S

Stefan Hoffmann

hi,
"MS Office Access cant find the form 'frmTimeCards' referred to in a macro
expression or VBcode"
Set rst = Form!frmTimeCards.RecordsetClone
There is a 's' missing as Form referres to Me.Form and you need
Forms!frmTimeCards.


mfG
--> stefan <--
 
G

Guest

hi Stefan hope you could help me...


Thanks
Stefan Hoffmann said:
hi,

There is a 's' missing as Form referres to Me.Form and you need
Forms!frmTimeCards.


mfG
--> stefan <--
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Recordset Clone 6
bookmark in subform 2
recordset - list box error (for search record) 3
Go to same Record/ Syntax Error 8
RecordSetClone Error 3
Recordset Clone 2
RecordsetClone 6
Data Member not Found 3

Top