Query to Table

[TechNat]

Is it possible to take a query, edit the fields in the query and then update the same table with the changed fields excluding duplicates?

I have been trying to find a solution for this for a while now. I can't figure out if I need to append the query to a custom made form or if I can edit the query directly and then save it into the table.

Any help would be greatly appreciated!
Thanks

 

[khawar]

If you update a query table will be updated automatically

 

[TechNat]

Thanks for the Help

Thanks for the help!

 

[l3on]

TechNat, not to hijack your thread but I was planning to post something similar and therefore thought it relevant.

If you update a query table will be updated automatically

I'm presuming that if you had a select query that selected a single record to populate a form, and field/s were editted, then these changes would be automatically updated to the original table. Is this correct?

I ask this because I have a form that was bound to a select query to copy a record and permit the user to edit any information before saving. I was finding after exiting form that the original record had the same (editted) information as the copied record and was currently trying to find information on why this occurs.

The next question would be how to stop this occurring? I am assuming I would have to unbind the form and populate the fields manually??

 

[khawar]

Select queries will update table as soon as the queries are update when you are using form to edit which is based on a query then you can use undo if you dont want to save changes

 

[l3on]

So in that case it would most probably be advisable to use an unbound form, populate specific fields from a query, and then Update/Append the table through SQL.

 

[TechNat]

Found the problem and corrected it!

For some reason my linked tables through ODBC were not letting me view the table. I found out that I have to have the table set to ready only.

Thank You Everyone for Your Help!