From: OldGuy on
I am using a query as a datasource for a subform. When I close the form, the
query is getting corrupted. If I open the query in design mode the
destination fields have disappeared.
From: John W. Vinson on
On Thu, 11 Feb 2010 06:26:06 -0800, OldGuy <OldGuy(a)discussions.microsoft.com>
wrote:

>I am using a query as a datasource for a subform. When I close the form, the
>query is getting corrupted. If I open the query in design mode the
>destination fields have disappeared.

Sorry, my clairvoyance isn't working very well today!

What version of Access?
What's the query? Could you post the SQL?

--

John W. Vinson [MVP]