Access Error Query must have atleast one destination field

[jaishu]

Hi ,
I am using a form based on a query. The form is locked and the fields are not editable, but when i just tried typing something, the contents on the form didnt change, but when i closed and opened the Form again, it came up with this error "Query must have atleast one destination field", i had been coming across this error several times and could not find a solution, typically i just pasted the query and it would be fine as long as i dont type in or try anything on the form. but Since more than 10 users use this application now , everyone gets this error and ï really dont know how to manage this.how to handle this error?

Pls help..Thanks so much!!

[Stewart Ross]

Hi ,
I am using a form based on a query. The form is locked and the fields are not editable, but when i just tried typing something, the contents on the form didnt change, but when i closed and opened the Form again, it came up with this error "Query must have atleast one destination field", i had been coming across this error several times and could not find a solution, typically i just pasted the query and it would be fine as long as i dont type in or try anything on the form. but Since more than 10 users use this application now , everyone gets this error and ï really dont know how to manage this.how to handle this error?

Pls help..Thanks so much!!

Hi jaishu. One possibility is that the form has an On Open, On Load or On Close event that is mistakenly trying to run a query that has no output fields. Check the event properties of the form check to see if there is an On Open, On Load or On Close event listed. If so, check what the event is doing - it could be a macro which is opening a dud query, or a VBA routine doing something similar.

If it is not an event handler, the remaining possibility is some kind of error in the recordsource of the form somewhere, but this is unlikely if you are seeing correct data in your form. The recordsource would have to be a query for it to be a potential problem; if the recordsource is a table you can rule it out as of any concern.

Let us know what you find.

-Stewart

[jaishu]

hi,

my form load doesnt have any other stmt other than(enabling the command button)
[code]
Enter.enabled =true
[code ends]

and no other form close or any other event.. the form is locked and cannot be edited (the table cannot be modified) its just a read only kind of Application.

Not only here i developed a few Access application and i ve been seeing this error, this is getting serious now because ( users are more ) and is just a read-only.

Thanks very much for your suggestions, pls let me know if you have any other ideas, i m researching on this right now.......

Thanks!

[jaishu]

Hi ,

i found that this error pops up due to change in the query(recordsou rce for the form).although the form is locked, if ,other options such as sorting is enabled and if there is any such operation on the form such as filter, sorting data etc, the query behind is changed (though not able to check) and if the form is closed and opened, it comes up with this message...
"query must have one destination field.......... ............"
i m trying to do some kind of lock..but any help on how to handle this is appreciated...

Pls..
Thanks!

[Stewart Ross]

Hi ,

i found that this error pops up due to change in the query(recordsou rce for the form).although the form is locked, if ,other options such as sorting is enabled and if there is any such operation on the form such as filter, sorting data etc, the query behind is changed (though not able to check) and if the form is closed and opened, it comes up with this message...
"query must have one destination field.......... ............"
i m trying to do some kind of lock..but any help on how to handle this is appreciated...

Pls..
Thanks!

Hi jaishu. Sorting or filtering in a form does not normally cause a modification to the recordsource itself. I doubt we can resolve this without seeing the form concerned and looking at the query dependencies that underly it. If it would help I am happy to check your database for you, which you could send to me by e-mail. If this is suitable please send me a PM to confirm and I will send you my e-mail address accordingly.

-Stewart

[NeoPa]

Jaishu,
Consider first attaching the (zipped version of the) database to this thread.
Also, in case it can help any, please review Example Filtering on a Form for further understanding of filtering.