I have a subform within my results form that I use to display the
results of my queries. Here is the problem: once the query has run and
its results are displayed in my subform - if you make any changes to
the information that is being displayed (changing the size of the
columns that are displayed within the subform or sorting the info
displayed in the subform), the query that produced the results has its
SQL code erased.
Here is my take on what is happening - when changes are made to the
results being displayed in my subform, the query must try to update or
refresh itself. In doing this, I think it must somehow overwrite its
own SQL code. If the database is to be saved at this point, the next
time I try to run the same query(the one whose result columns I made
wider), I get an error that says "Query must have at least one
destination field" and when I look at my query my SQL code is
overwritten with "SELECT;".
If I leave my database in read only mode this problem does not occur.
Since someone else will have to maintain my database in the future, I
don't want to leave this person with the hassle of possibly having
their queries erased if they turn off the read only property to make
small changes to the database.
If anyone has had this problem or can offer any insight please let me
know.
Thanks very very much
results of my queries. Here is the problem: once the query has run and
its results are displayed in my subform - if you make any changes to
the information that is being displayed (changing the size of the
columns that are displayed within the subform or sorting the info
displayed in the subform), the query that produced the results has its
SQL code erased.
Here is my take on what is happening - when changes are made to the
results being displayed in my subform, the query must try to update or
refresh itself. In doing this, I think it must somehow overwrite its
own SQL code. If the database is to be saved at this point, the next
time I try to run the same query(the one whose result columns I made
wider), I get an error that says "Query must have at least one
destination field" and when I look at my query my SQL code is
overwritten with "SELECT;".
If I leave my database in read only mode this problem does not occur.
Since someone else will have to maintain my database in the future, I
don't want to leave this person with the hassle of possibly having
their queries erased if they turn off the read only property to make
small changes to the database.
If anyone has had this problem or can offer any insight please let me
know.
Thanks very very much