Action query cannot be used as row source

[JH40]

I have a report where the text boxes were successfully populating from a query. I had to change the query process and append new data, so I created a table of the result instead. I am now updating the text boxes to read from the table and am now getting the above error message. Does anyone know why the report will not acknowledge the change to the table? It seems as if it still thinks the query is the source (query has been changed to a make table query and an additional append query runs after that) and sees that that query is now actionable. Stumped here...

Text box used to be:
ProvNumber

Text box should now be (but receives error):
=[tblProvider]![ProvNumber]

 

[SpentGeezer]

It appears that the action query is still the source for the report. Have you tried changing the source of the report to the new table?

 

[vbaInet]

If you want changes made to the source of your report to reflect whilst the report is open, you will either re-open the report or requery it.

@Spent: You didn't use pink? What's going on?

 

[SpentGeezer]

Feeling blue at the moment....

 

[vbaInet]

Feeling blue at the moment....

Ah! Alright then