[AccessD] FindFirst Not Working

Rocky Smolin rockysmolin at bchacc.com
Sun Jul 12 08:47:30 CDT 2009


Dear List:

Legacy app.  I added a form to make purchase orders. In the AfterUpdate
event of the combo box which finds an existing purchase order I added the
following:


Private Sub cboFindPO_AfterUpdate()
    Me.Recordset.Clone.FindFirst "fldPOHID = " & Me.cboFindPO.Column(0)
    MsgBox Me.RecordsetClone.NoMatch
    Me.Bookmark = Me.RecordsetClone.Bookmark
    Me.Refresh
End Sub

But the form does not move to the selected Purchase Order.

I put in the MsgBox just to make sure NoMatch was False.  I added the
Refresh to see if that was the problem.

Does anyone see a reason why this shouldn't work?  

MTIA,

Rocky




More information about the AccessD mailing list