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.
When cycling through records in frm_WORKING (I need you to create the "Current Action" vba script)
IF [tbl_EMPS].[CODE] is not null
Copy/Paste the [tbl_EMPS].[CODE] into [tbl_WORKING].[CODE]
WHERE [tbl_EMPS].[IDField] = [tbl_WORKING].[IDField]
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.
8 freelancere byder i gennemsnit $28 på dette job
Nice work, Consider it done , finding matching records between 2 tables You can get all matching record between the 2 tables on one screen at once too USD 30 , 1 day CHEERS!