puakenikeni
Registered User.
- Local time
- Today, 01:50
- Joined
- Jun 24, 2008
- Messages
- 25
The control source of my subform is a query. The form runs okay (I'm having problems here and there, but I'm getting my answers!), but if I switch to design mode and then back to form mode, for some reason, it "clears" out the query. I get the error "Query must have at least one destination field". When I check the query itself, all of the SQL code is gone. I only have the "SELECT" clause. I don't believe I have anything in my code that deletes the code in the query, so I don't know why it's behaving like this.
Any suggestions?
Any suggestions?