I don't understand. Once you modify the SQL statement in the querydef, then just open the query like normal with Docmd.Openquery.

The string of fields is too long

This is the string of fields I want to pull from the table, but I don't know how to specifically list them out as the string is too long
SELECT TBL_DMHRSI_STAFF_PRD.DATE_PULLED, TBL_DMHRSI_STAFF_PRD.TI_CD, TBL_DMHRSI_STAFF_PRD.EDIPI, TBL_DMHRSI_STAFF_PRD.DUPLICATE_EDIPI, TBL_DMHRSI_STAFF_PRD.DMHRSI_EMP_NUM, TBL_DMHRSI_STAFF_PRD.FULL_NAME, TBL_DMHRSI_STAFF_PRD.PERSON_TYPE, TBL_DMHRSI_STAFF_PRD.TITLE_RANK, TBL_DMHRSI_STAFF_PRD.UPDATED_EMAIL, TBL_DMHRSI_STAFF_PRD.VALIDATED_EMAIL, TBL_DMHRSI_STAFF_PRD.NOT_IN_GLOBAL, TBL_DMHRSI_STAFF_PRD.IN_GLOBAL_NO_EMAIL, TBL_DMHRSI_STAFF_PRD.PERSON_UIC_OR_PAS, TBL_DMHRSI_STAFF_PRD.ORGANIZATION_NAME, TBL_DMHRSI_STAFF_PRD.PERSON_EFFECTIVE_START_DATE, TBL_DMHRSI_STAFF_PRD.PERSON_EMAIL_ADDRESS, TBL_DMHRSI_STAFF_PRD.POSITION_EFFECTIVE_START_DATE, TBL_DMHRSI_STAFF_PRD.POSITION_TITLE, TBL_DMHRSI_STAFF_PRD.SUPERVISOR_FULL_NAME, TBL_DMHRSI_STAFF_PRD.SUPERVISOR_EDIPI, TBL_DMHRSI_STAFF_PRD.SUPERVISOR_EMAIL, TBL_DMHRSI_STAFF_PRD.PERSON_SERVICE, TBL_DMHRSI_STAFF_PRD.PERSON_GRADE
FROM TBL_DMHRSI_STAFF_PRD

WOW

BTW, Thank you for even looking at this on a Saturday!

I don't understand, again. Your object names above are completely meaningless, so why don't you explain to me in English what everything represents, or rewrite it so someone who doesn't understand your names can comprehend it. What's a cmb_SUT_TI_CD? No clue. See: All About Context

If it's one table, you could start by removing the table name from each of the fields. You don't need it in a single-table query.

Next, shorten those field names up. If you don't want to modify the original table, create a query and Alias them.

FN is better than TBL_DMHRSI_STAFF_PRD.FULL_NAME

The string of field names is too long to post into VBA

Okay, was wondering if there was a similar function to a VBA script " _" I had missed in your earlier classes.

Greg,

Read and follow the advice from Richard above.

OK, then shorten it (see 2 previous suggestions).

Oh, well, yeah, you could break that up into multiple strings with _ if you want.

X = "SELECT this, that, the, other, thing " & _
"FROM mytable"

or if there was a way to just edit the WHERE clause while leaving the SELECT & FROM Statements alone in the underlying Pass Through Query

I think your BEST BET is to make a View on the server with shorter field names.

Does the " _" hold even within the SELECT Statement? For instance having multiple rows within just that statement?

Roger that.  It isn't my table, but can certainly pull in a new view on the server side.  Thanks to both of you for your input!

THa

Sure. You're just creating a string. Make the string first, then you can MsgBox it to make sure it's correct, and then assign it to your querydef. But I still think you'll benefit from smaller field names.

Thank you!  Get back to the beers and brats and I am very grateful for the weekend input.

I took last week off to go to Jamaica... so I'm catching up this week. :)

That was time well spent. BTW, are you doing courses on Python?

I have assumed that you already declared the variable for the record set , then simply use the code like below + a criteria:

Set rst = db.OpenRecordset("select vsdcRcptPbctDate,rcptNo,intrlData,rcptSign,sdcId,SqrCode FROM [tblCustomerInvoice] WHERE [InvoiceID] = " & Me.txtJsonReceived)