ODBC to MS SQL server tables from Access

[sariahdog]

I created an Access 2000 database a few years ago and ressurectected it recently with Access 2007. The database connects via ODBC to SQL server tables.
I recently added an access form with one combo box that uses one of the ODBC tables to fill in its vaules. The user selects a value from the combo box, a select query is run which uses the selection value to display results from another table. The results selected are correct but then the second table gets records modified for some reason. This modifing is unexpected behavior and will detroy the integrity of the data. Anyone ever run into this before or have any sugestions for trouble shooting? The select query is as follows

PARAMETERS [Y or N] Text ( 255 );
SELECT dbo_PROJECT.pjct_id, dbo_PROJECT.pjct_describe AS Description, dbo_PROJECT.pjct_cust_name AS Customer, dbo_PROJECT.pjct_tp_code AS TPCode, qryDevResource.res_name AS B2BLead, qryDevResource_1.res_name AS B2BDev, qryCSSResource.res_name AS CSS, dbo_PROJECT.pjct_receive_date AS ReceiveDate, dbo_PROJECT.pjct_compl_rqst AS CompletionRequested, dbo_PROJECT.pjct_compl_perc AS [Completion%], dbo_PROJECT.pjct_compl_actl AS CompletionActual, dbo_PROJECT.pjct_type AS Type, dbo_PROJECT.pjct_cat AS Category, dbo_PROJECT.pjct_active
FROM ((dbo_PROJECT LEFT JOIN qryDevResource ON dbo_PROJECT.pjct_is_res_lead_id=qryDevResource.res_id) LEFT JOIN qryDevResource AS qryDevResource_1 ON dbo_PROJECT.pjct_is_res_dev_id=qryDevResource_1.res_id) LEFT JOIN qryCSSResource ON dbo_PROJECT.pjct_css_res_id=qryCSSResource.res_id
WHERE (((qryDevResource.res_name)=forms!frmResourceProject!cmbResource) And ((dbo_PROJECT.pjct_active)=[Y or N])) Or (((qryDevResource_1.res_name)=forms!frmResourceProject!cmbResource) And ((dbo_PROJECT.pjct_active)=[Y or N]));