INSERT INTO Report_Intermed ( ProvName, ProvSSN, Claim, DateOfSvc, Payment, Something )
SELECT dbo_PROVIDER.NAME, dbo_PROVIDER.SS_NUMBER, zstblClaimsAdjStatus.CLAIM_NUM, zstblClaimsAdjStatus.DATE_FROM, zstblClaimsAdjStatus.PAY_DOLL, IIf(Forms!frmProcessAdjClaims.fraMode = 1, ([VendorID] is not null AND [VendorID] > ‘ ‘),([VendorID] is null or [VendorID] = ‘ ‘)) AS CTLFI
FROM zstblClaimsAdjStatus INNER JOIN dbo_PROVIDER ON zstblClaimsAdjStatus.PROV_ID = dbo_PROVIDER.PROV_ID
WHERE CTLFI AND zstblClaimsAdjStatus.BILLED_FLG<>0
ORDER BY dbo_PROVIDER.NAME;
I am expecting CTLFI as a boolean. When I run the query from VBA in form frmProcessAdjClaims I get asked for the value of CTLFI. When I run the query by itself I get asked for fraMode, which is fair enough, but then also for CTLFI, which appears to be defined already.