Re: Complex query - readonly recordset workaround
Ah thanks for replies, yes I will try a separate form on a pop up. DBGuy - sorry for "it isn't working" as I appreciate that that is so useless (although Pat understood...). No there is no error, the form simply opens as it would otherwise do according to the arguments built into 'On Open'.
PS Why doesn't DoCmd.Close happen before DoCmd.Open when it is told to do that?