I read it, but it didn't make sense until I was able to look at the SQL code for the query. I've only ever used design view and the wizards, and I never looked for the SQL view before. Thanks.
SQL from the query that allows user to update the data from the query:
SELECT DISTINCTROW...
My problem is almost identical. I used to be able to update data using a form that uses query. The old copy of the database from February still works. The current copy of the database does not. I have not revised any of the code that I can remember. Today I imported some data and I noticed the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.