strCriteria = "Doneby = " & Me!Doneby & " AND StopTime = Null"
----- Original Message ----- From: "brazilianbound" <[EMAIL PROTECTED]> To: <AccessDevelopers@yahoogroups.com> Sent: Thursday, December 08, 2005 11:54 AM Subject: [AccessDevelopers] Launching a FindRecord from an event > HI guys > > I am attempting to execute a search on a before_Update event. But this > is not working below. > > Basically, when i scan the "Doneby" field, I want it to look in that > field to see if there is a value in it. IF there is a value there and > the "StopTime" field is Null, then search for the value in the "doneby" > field and populate the StopTime & StopDate fields. > > Private Sub Doneby_BeforeUpdate(Cancel As Integer) > Dim strCriterias As String > Dim rst As Recordset > Set rst = Me.RecordsetClone > strCriteria = "Doneby = " & Me!Doneby > strCriteria = "StopTime" = Null > rst.FindFirst strCriteria > Me.Bookmark = rst.Bookmark > End Sub > > > As Always, Grateful, Clayton > > > > > > > > Please zip all files prior to uploading to Files section. > Yahoo! Groups Links > > > > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income households are not online. Help bridge the digital divide today! http://us.click.yahoo.com/I258zB/QnQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
