I have a continuous form where the record source is a query.
I want to keep the form, but change the record source. I want to change the record source to a table. When I do this, it does not work.
I have copied the query that worked and renamed it. I changed the fields selected in the query. When I use this renamed query, it works
Why is it working this way? I thought I could just change the record source to anything I want.