I'm having trouble using a bookmark to move to a record.
I have 2 forms, each is bound to 1 table.
From the PM form I can Open the PX form. In the PX form,
I'll change the status of the product. Changing to a certain status
will delete the record from the PM table. What I'd like to do at this point
is have the PM form move to the record that was right before the record I deleted. The problem is, I always end up on the first record.
Here's the code I'm using:
If SysCmd(acSysCmdGetObjectState, acForm, "Product Master") = acObjStateOpen Then
'the product master form is open
Dim rstfrm As DAO.Recordset, strBkMk As String
Set rstfrm = Forms![product master].RecordsetClone
If rstfrm.BOF Then
strBkMk = rstfrm.Bookmark
Forms![product master].Bookmark = strBkMk
Set rstfrm = Nothing
Does anyone see anything I'm missing????
Inspiration Through Fermentation