Access Auto Update Field from one Table to Another.

[batcater98]

I have two tables in access - In the primary table when a record is created I want to automatically use the primary key from this table and search for that key in another table. If found I want to "Clear" that value from the secondary table and leave it blank.

How would I do this? SQL, VB, Macro.. What would be best.

Thanks.

 

[PHV]

One way is to use the AfterInsert event procedure of the form used to populate the primary table and launch an UPDATE statement with the DoCmd.RunSQL method.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886