Thanks Tobi - i'll make those changes! --- In [email protected], "Hoffman, Tobi K \(DYS\)" <[EMAIL PROTECTED]> wrote: > > I don't know where your "|" error is, but if you are hoping to have an > interval of 8000 and then close the splash form, you need to do it > differently. First, you need to use "frmSplash_JobCancel" instead of > "Splash_JobCancel", and then in the properties for the splash form, set > the TimerInterval to 8000, and in its Timer event, put in the > DoCmd.Close line. What you are doing here is setting the TimerInterval > for the form that the code is in, and it won't produce the pause that I > think you are looking for. > > Tobi > > -----Original Message----- > From: [email protected] > [mailto:[EMAIL PROTECTED] On Behalf Of brazilianbound > Sent: Monday, December 19, 2005 12:44 PM > To: [email protected] > Subject: [AccessDevelopers] If Statement problem > > > Morning! > > I'm getting an error message saying that it can't "|" field in my > expression. I don't see that, any help is appreciated! > Thanks - Clayton > > Private Sub ReworkNo_AfterUpdate() > If (Me.ReworkNo) = [p job table].ReworkNo And [p job table].JobCancel = > Yes Then > DoCmd.OpenForm "Splash_JobCancel", acNormal, , , , acWindowNormal > Me.TimerInterval = 8000 > DoCmd.Close acForm, "frmSplash_JobCancel" > End If > > > > > > > > > > Please zip all files prior to uploading to Files section. > Yahoo! Groups Links >
------------------------ Yahoo! Groups Sponsor --------------------~--> AIDS in India: A "lurking bomb." Click and help stop AIDS now. http://us.click.yahoo.com/9QUssC/lzNLAA/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/
