P
Paul
I am trying to close forms in a newly upsized adp
(everything worked fine as an mdb) - My parent form
(FSJobs)is unbound and my subform is continous records
which has as its recordsource an SQL statement directly
in the properties window.
To close the form I have a Command button which runs the
code
DoCmd.Close acForm , "FSJobs"
My FSJobs closes as does the subform - then however it
opens itself up again.
Commonly this would be caused by a line of code
referencing either the parent of child form again once
they are closed forcing them to open ie a .Requery
non of this is the case.
Something else causes the forms to reopen "automatically"
Using file close and closing with windows close button
closes the forms fine.
Anyone know what causes this - and how do I solve it??
Thanks
(everything worked fine as an mdb) - My parent form
(FSJobs)is unbound and my subform is continous records
which has as its recordsource an SQL statement directly
in the properties window.
To close the form I have a Command button which runs the
code
DoCmd.Close acForm , "FSJobs"
My FSJobs closes as does the subform - then however it
opens itself up again.
Commonly this would be caused by a line of code
referencing either the parent of child form again once
they are closed forcing them to open ie a .Requery
non of this is the case.
Something else causes the forms to reopen "automatically"
Using file close and closing with windows close button
closes the forms fine.
Anyone know what causes this - and how do I solve it??
Thanks