Hi All
I'm currently having a problem with a macro where I can't get a form to close on cue.
I have a value on Form A which the Macro uses to filter results on Form B so I can't close Form A before opening Form B.
I can't do anything with the database other than use Form B. Once I have finished with Form B, Form A then closes.
Here is the code i'm using, (I have tried the Close function everywhere in this code segment)
ACTION ARGUMENTS
Open Form Contact Details, Form, , ="[ID]=" & [Screen].[ActiveControl], , Dialog
Close Form, , Yes
OnError Next,
ReQuery =[Screen].[ActiveControl].[Name]
Any help would be greatly appreciated as it's currently driving me nuts.
Thanks in Advance
Matt