You probably know that you can base a form or report on a query as well as a table. What you might not realize is that the query must be a Select query. You can't base a form or report on an Action query (Delete, Update, Make-Table, and Append).

The workaround is simple--base your form or report on the result of the Action query, not the query itself. While this tip may seem obvious, it's easy to make this mistake when you're used to basing forms and reports on queries

Access Index

Main Index