Hi, I am an experienced VBA user but new to Access reporting. I am trying to assign a recordset to a report that is the result of some coding work done on a query. I have been able to use this query, manipulate the data, and then assign it to a listbox, but I cannot do this to a report (by using the recordsource property). How do you assign data to a report that is not directly from a SQL query or existing table?

Can you explain what you mean by " I am trying to assign a recordset to a report that is the result of some coding work done on a query."?

It sounds like there is a query. Is it a saved query, or a string in your code?



mmcdonal

thanks for responding. The query is a string query run in VBA using the recordset object. I cycle through the recordset looking for certain values which are then used to grab values from additional tables. The recordset is then updated to replace the original values with the new values. I would like to assign the final recordset to a report, but don't know how to do so. Does this make sense?

When you find the certain values you seek, append each record into a temporary table and then make THAT the record source of the report.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division