Access VBA - Event

I have an Access DB. 2 tables, one form. As I cycle through records on the form I need the system to check a matching ID field between the tables and copy some information from one table to another. tbl_EMPS tbl_WORKING frm_WORKING When cycling through records in frm_WORKING (I need you to create the "Current Action" vba script) IF [tbl_EMPS].[CODE] is not null WHERE [tbl_EMPS].[Active]=True THEN Copy/Paste the [tbl_EMPS].[CODE] into [tbl_WORKING].[CODE] WHERE [tbl_EMPS].[IDField] = [tbl_WORKING].[IDField] Else 'do nothing So when a record loads, go see if the matching IDField is ACTIVE in tbl_EMPS, if so copy the CODE from that same active line into the CODE field of the form.