[AccessD] FindFirst Not Working

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
> 




More information about the AccessD mailing list