Form not displaying Bookmarked record

[EddyLLC]

I use the following code behind a control on a form to delete a record and then call up the previous record. There can be multiple Inv's per FileNo. It seems to find the match, Me.RecordsetClone.NoMatch is returned as false, but the previous record is not displayed. The first record in the table is displayed as if I just opened the form. Any thoughts?

RunCommand acCmdDeleteRecord
vFind = "FileNo = '" & strFile & "' AND Inv = '" _
& strInv & "'"
Me.RecordsetClone.FindFirst vFind
Me.Bookmark = Me.RecordsetClone.Bookmark

 

[PHV]

And this ?
Dim rst As DAO.Recordset
Set rst = Me.RecordsetClone
rst.FindFirst vFind
Me.Bookmark = rst.Bookmark
Set rst = Nothing

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[EddyLLC]

Yes with the same result. The first record in the table is displayed instead of a previous invoice of the same file nmber. Very frustrating.

 

[KenReay]

HI

Try

vFind = "FileNo = '" & strFile & "' AND Inv = '" _
& strInv & "'"
Me.RecordsetClone.FindFirst vFind
If Me.RecordsetClone.NoMatch Then
msgBox "Not Found"
Else
Me.Bookmark = Me.RecordsetClone.Bookmark
End If

What happens?

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK