Access form deleting query making form inoperable

[papadega3000]

I have encounter a rather wierd error within Access where it seems that somehow when I was making alterations to the form(adding a page) then saving the form Access seemed to have deleted the query the drives the form and the form becomes blank. A message pops up saying there needs to be a destination field in the query. I am not sure why this happens. I have a few screen snaps that show what I am seeing.

Maybe someone ran into this before this is a first for me.

 

[papadega3000]

A little more debugging showed me with a fresh copy of a backup db that when I insert some sql code for a query that runs the form and save the query then re-open the form the dissappears. Now there are two other queries in the subforms on that form that the queries did not delete themselves. however those were built with the query builder not with SQL Code.

Has anyone seen something like this????

 

[boblarson]

You might have a corrupt database (or in the least a corrupt form). Have you tried importing everything into a brand new, blank mdb file?

 

[papadega3000]

Hello,

I haven't tried that yet but that is on the list of things to try. I already tried using an old backup and that obviously didn't work but if I get time today I am going to rebuild that form, or entering the query that way and see if it breaks the db.
I will keep this post updated if I noticed anything new or I somehow fix it.

Thanks.

 

[papadega3000]

It appears to be a corrupt query and form. I believe the form was corrupting the query in some way because it would only be after the first time the query was run through the form that the query would disappear. I re-created the form and rebuilt the query using the query builder instead of the sql code and it worked.

 

[boblarson]

Glad you got that sorted