Can I get some assistance with the T SQL syntax required to use the contents of this combo box in a pass thru query in order to improve performance response time over the LAN
[Forms]![WELCOME]![FILTER_BUILDER].[Form]![Combo28]
Apparently TSQL doesn't like the "!" from Access:
SELECT dbo_A_VIEW_LOWEST_LEVEL.contract, dbo_A_VIEW_LOWEST_LEVEL.[Profit Center Name], dbo_A_VIEW_LOWEST_LEVEL.MATERIAL_DESC, dbo_A_VIEW_LOWEST_LEVEL.cust_Name, dbo_A_VIEW_LOWEST_LEVEL.cust_id, dbo_A_VIEW_LOWEST_LEVEL.mat_id, dbo_A_VIEW_LOWEST_LEVEL.pc, dbo_A_VIEW_LOWEST_LEVEL.MEMO, dbo_A_VIEW_LOWEST_LEVEL.SUP_ACCT, dbo_A_VIEW_LOWEST_LEVEL.act_id, dbo_A_VIEW_LOWEST_LEVEL.actuals, dbo_A_VIEW_LOWEST_LEVEL.budget, dbo_A_VIEW_LOWEST_LEVEL.forecast, dbo_A_VIEW_LOWEST_LEVEL.link, dbo_A_VIEW_LOWEST_LEVEL.bud_var, dbo_A_VIEW_LOWEST_LEVEL.fcst_var, dbo_A_VIEW_LOWEST_LEVEL.CDEPMNT, dbo_A_VIEW_LOWEST_LEVEL.MNTATT, dbo_A_VIEW_LOWEST_LEVEL.MNTCM, dbo_A_VIEW_LOWEST_LEVEL.MNTCPI, dbo_A_VIEW_LOWEST_LEVEL.MNTCPROB, dbo_A_VIEW_LOWEST_LEVEL.MNTHELD, dbo_A_VIEW_LOWEST_LEVEL.MNTIMPOC, dbo_A_VIEW_LOWEST_LEVEL.MNTIMSD, dbo_A_VIEW_LOWEST_LEVEL.MNTMIGR, dbo_A_VIEW_LOWEST_LEVEL.MNTOTH, dbo_A_VIEW_LOWEST_LEVEL.MNTQ4IM, dbo_A_VIEW_LOWEST_LEVEL.MNTRECVD, dbo_A_VIEW_LOWEST_LEVEL.MNTSWSD, [pc] & [cust_id] AS CUSTLINK, dbo_A_VIEW_LOWEST_LEVEL.MNTIMPOC
FROM dbo_A_VIEW_LOWEST_LEVEL
WHERE (((dbo_A_VIEW_LOWEST_LEVEL.SUP_ACCT)=[Forms]![WELCOME]![FILTER