[AccessD] FindFirst Not Working

Rocky Smolin rockysmolin at bchacc.com
Sun Jul 12 14:55:09 CDT 2009


I believe so.  The first column is the PO Header ID (column width zero), the
second column is the PO Number. Bound column is 1 but there's no control
source so I think it should make no difference.



Rocky
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William Hindman
Sent: Sunday, July 12, 2009 9:45 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] FindFirst Not Working

...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
> 

-- 
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