In a Data Environment Command sql statement I want to set the name to be retrieve to equal the combo1 text. Also, how would I refresh a datagrid in combo_click event? This what I have:

SELECT Name, Account, Qtr1
FROM Act
WHERE name = '" & Trim(frmDataEnv.Combo1.Text) & "' AND
(Account = 'ret_prem_g' OR
Account = 'nii_gaap_inya' OR
Account = 'reclass_rcg' OR
Account = 'tot_revenue' OR
Account = 'tot_benefit' OR
Account = 'tot_inc_fpb' OR
Account = 'tot_acq_exp' OR
Account = 'opex_gaap_inya' OR
Account = 'tot_deduct' OR
Account = 'life_gaap_opinc' OR
Account = 'tot_rcg_bef_taxmi' OR
Account = 'life_net_inc')