[AccessD] FindFirst Not Working

The technical term is screw up. There are more generic terms in common
parlance, however. 

Rocky


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

Line 1: Me.Recordset.Clone.FindFirst
Line 2: Me.RecordsetClone.NoMatch

Rocky,

What is the difference between
Recordset . Clone in Line 1
and RecordsetClone in line 2?
(typo?)

-
Michael R Mattys
MapPoint and Database Dev
www.mattysconsulting.com
-

----- Original Message -----
From: "Rocky Smolin" <rockysmolin at bchacc.com>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Sunday, July 12, 2009 9:47 AM
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