I have a simple Access reported generate off/from a specific query - this obviously generates a record set somewhere.

I need to edit this record set directly in order to edit/delete records before actually doing the print

Question: How do I get to the report's record set so I can manipulate it in code.

Any suggestions would be greatly appreciated

TaraJ

Welcome, Tara.

If your query is a Make-Table query, you can find out the name of your table by viewing it in design view and clicking on the menu QUERY > MAKE TABLE QUERY and seeing what's in the table name field.

The way to add, delete, and/or edit records in a table is to create a form based on a table. Do not get into the habit of doing that directly in the table.

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