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: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of brazilianbound Sent: Monday, December 19, 2005 12:44 PM To: AccessDevelopers@yahoogroups.com 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 --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/KIlPFB/vlQLAA/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/
