
July 2nd, 2003, 03:08 AM
|
|
Contributing User
|
|
Join Date: Aug 2002
Posts: 91
Time spent in forums: < 1 sec
Reputation Power: 6
|
|
|
changing subform layout wipes query in Access
Hi
I have a form in Access 2000 that has several different search fields that have corresponding queries to populate a subform with data.
It is working great in loading up the data but the thing is that when you change the layout of the fields, i.e. the horzintal space of a column in the subform, it asks you if you want to save the changes to the query. If you say yes then it wipes the contents of that query making it...
"SELECT ;"
I am wondering if anyone has experinced this and has a solution to not let the form edit the query. Otherwise I will give to someone and they will wipe out all the queries in no time at all!
Thx in advance.
|