Hello Everybody

i have two form and two tables(access 2007) ; Supplier form and Product form are linked to Supplier table and Product table by the use of "Adodc"

i want to use the records of SupplierID in the supplier table to insert it into the Product Form by the use of a combobox and save the selected supplier ID to my Product table

Please help i'm not able to do this??