How to capture value of a field from parameter driven query

[Rick_S.]

Hi folks,



New account & first post... so please bear with me.

I have a parameter driven query that will always return at least one line of output. The goal is to export the queried data to an Excel spreadsheet. So far, everything I've described works just fine.

The problem is in naming the newly exported Excel file. I would like to use the value of two fields in the query to build a file name. It does not matter which row from the query the values come from as the values are all the same for any given execution of the query.

The first of the two fields is named "ORG"; is of string type and always has 3 characters and is the left most column in the results.

The second of the two fields is named "Campus_Dept" and always has 10 or more characters and is the 2nd column in the results.

I run the query with a DoCmd.OpenQuery, but have been unsuccessful in capturing the two values needed. I tried a DLookup, but got an error message: "Run-time error '3326 This Recordset is not updateable."

Any and all help greatly appreciated.

Hope all is well & till later,
Rick S.
San Antonio, TX

[Bob Fitz]

Can you show us the code for the DLookup() that you used.

[Rick_S.]

Hi again,

m_org = DLookup("[ORG]", "Q_Individual_ORG_Detail_Parameter")

m_org is a local variable used later to name the exported spreadsheet

[ORG] is a field returned by the query

Q_Individual_ORG_Detail_Parameter is the name of the parameter driven query

I've omitted the optional "Where" clause as all the ORG values are the same; actually tried with and w/out the "Where", but the results were the same.

Thoughts ?

Many thanks & till later,
Rick S.