Search results

Thanks Bob. You pointed me the right way, and I then read your section on "Surviving subqueries" and ended up using a DLookup instead of my joined query/subquery. It worked great.

I have been working on a form which is based on a query which joins a few tables. It has been working as expected including having the ability to modify the underlying data using the form. I have made a change to the query by joining another query to it which allows the addition of a single new...