Thanks for your reply. I have removed all non-alphanumerics and aliases and still nothing. If I replace all fields with SELECT * , it still does the same thing.
Because it's a Navigation Subform. Either I cant edit field names with a VBA Query or i don't know how.
Hi, I am having issue displaying results in a navigation subform table. The record source is a dynamic query done in VBA. When the query is run manually it shows results with all requested fields. However, when done in runtime it only shows that it's picking up the records but not the fields...