Actually, strCriteria = "Doneby = " & Me!Doneby & " AND IsNull(StopTime)"
HTH, Toby ----- Original Message ----- From: "Toby Bierly" <[EMAIL PROTECTED]> To: <AccessDevelopers@yahoogroups.com> Sent: Thursday, December 08, 2005 11:58 AM Subject: Re: [AccessDevelopers] Launching a FindRecord from an event > 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 > > > > > > > > > > > > > > > > > > Please zip all files prior to uploading to Files section. > Yahoo! Groups Links > > > > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> 1.2 million kids a year are victims of human trafficking. Stop slavery. http://us.click.yahoo.com/.QUssC/izNLAA/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/
