Populating textbox based on another textbox from MS Access Tables

Mar 4 2009 5:10 AM

Hi, I have a 2 text boxes tbox1 and tbox2 now i want to populate tbox2 when a value is entered in tbox1...how this can be done?

note: Supplier Table
tbox1: SuppilerID
tbox2: SupplierName..Should populate when supplierID is entered.

How this can be done. As I am using MSAccess db...

Please help out