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