Search results

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...