my problem is:
i have a field custID in Orders table, which must be in Customers table.
what i wont is: when i fill the cusID field-pass the correct cusName, after i move to another field on the Orders form.
thnk you all
p.s. the connection to recordset in Customers table is ok.
i think the main problem is where do i put my select? is there any event like After update field... or something......