اشكرك اخي ابو رائد لكن المشكلة لم تحل وهذا الكود اللي اريد اكتبة........
de.rsCommand1.Open "SELECT contract_information.contract_id,contract_information.contract_name,contract_information.contract_company_name, contract_information.contract_amount, contract_information.contract_super_vision,contract_information.contract_super_vision_by,contract_information.contract_percent,contract_information.contract_time,contract_information.contract_warning,site_information.site_city_name, committees.committee_cmbo_prim,committees.committee_prim_chief, committees.committee_txt_prim,committees.committee_prim_panelist_first,committees.committee_prim_panelist_second,committees.committee_prim_panelist_third,committees.committee_prim_panelist_fourth,committees.committee_prim_panelist_fifth,committees.committee_txt_final, committees.committee_cmbo_final,committees.committee_final_panelist_first,committees.committee_final_panelist_second,committees.committee_final_panelist_third,committees.committee_final_panelist_fourth,committees.committee_final_panelist_fifth
FROM contract_information, site_information, committees WHERE (contract_information.contract_id = site_information.contract_id) AND (contract_information.contract_id = committees.contract_id) and(site_information.site_city_name='& txt_city &')"
de.rsCommand1.Open "SELECT contract_information.contract_id,contract_information.contract_name,contract_information.contract_company_name, contract_information.contract_amount, contract_information.contract_super_vision,contract_information.contract_super_vision_by,contract_information.contract_percent,contract_information.contract_time,contract_information.contract_warning,site_information.site_city_name, committees.committee_cmbo_prim,committees.committee_prim_chief, committees.committee_txt_prim,committees.committee_prim_panelist_first,committees.committee_prim_panelist_second,committees.committee_prim_panelist_third,committees.committee_prim_panelist_fourth,committees.committee_prim_panelist_fifth,committees.committee_txt_final, committees.committee_cmbo_final,committees.committee_final_panelist_first,committees.committee_final_panelist_second,committees.committee_final_panelist_third,committees.committee_final_panelist_fourth,committees.committee_final_panelist_fifth
FROM contract_information, site_information, committees WHERE (contract_information.contract_id = site_information.contract_id) AND (contract_information.contract_id = committees.contract_id) and(site_information.site_city_name='& txt_city &')"