Thanks Tobi - have a great afternoon! I'll apply that change and see what happens.
Thanks! --- In [email protected], "Hoffman, Tobi K \(DYS\)" <[EMAIL PROTECTED]> wrote: > > Don't know if this will help, but I advise naming the textbox > "txtDoneBy" and using Me.txtDoneBy. The reason is that if the data in a > textbox is not yet saved, Me.DoneBy will not yet necessarily have a > value, but Me.txtDoneBy will. > > I'm heading out now, may catch up with this from home if Toby can't > pitch in! > > Tobi > > -----Original Message----- > From: [email protected] > [mailto:[EMAIL PROTECTED] On Behalf Of brazilianbound > Sent: Thursday, December 08, 2005 4:21 PM > To: [email protected] > Subject: [AccessDevelopers] Record Find is Hanging > > > When i scan the "Doneby" is is hanging on > rst.FindFirst strCriteria > > saying Method or Data Member not found. > > What gives? (oh my head hurts) LOL > > Clay > > ps - what do you guys want for x-mas! > > > Private Sub Doneby_BeforeUpdate(Cancel As Integer) > Dim strCriterias As String > Dim rst As Recordset > Set rst = Me.RecordsetClone > > If Not IsNull(Me.Doneby) Then > strCriteria = "Doneby = " & Me!Doneby & _ > " AND IsNull(StopTime)" > rst.FindFirst strCriteria > Me.Bookmark = rst.Bookmark > End If > > > > > > > > > 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/
