Hi folks,

Sorry for the long post...

I have a Query that asks for a parameter.  Once the query has run, I want to export the resulting records to an Excel spreadsheet, using the value of two fields as part of the new spreadsheet naming convention.

I'm still something of a "newbie" in VBA, so am struggling on how to capture the value of a text field named "ORG"  and another text filed named "Campus_Dept".

I have tried DLookup, but keep getting a "3326 - Recordset is not updateable"  error message.

I have over 100 "ORG's" to process... and will end up repeating this whole evolution about every 2 months or so.

Please advise how best to be able to capture the actual value of these two fields  "ORG"  and  "Campus_Dept"  from a parameter driven query that will alwasy return at least 1 row.

Much appreciated & till later,
Rick Stockstill
San Antonio, TX

---

Reply from Alex Hedley:

You could add those values as a column to your Query then when you export they'd show, but they'd be there for every row.