William Hindman
wdhindman at dejpolsystems.com
Sun Jul 12 11:45:15 CDT 2009
...is your column id correct? ...Column(1) vs Column(0) William -------------------------------------------------- From: "Rocky Smolin" <rockysmolin at bchacc.com> Sent: Sunday, July 12, 2009 9:47 AM To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com> Subject: [AccessD] FindFirst Not Working > 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 > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >