I am using an Access 2002 project to connect to a SQL 2000 database and need help with a VB script for my form.

I have an Access form that inserts data to TABLE “A” from a ComboBox.
The ComboBox does a lookup from TABLE “B” column “1”
Based on the ComboBox selection, I want to also INSERT additional row values from TABLE “B” fields “2” and “3” to fields in TABLE “A”.

I need to know how to write the VB code on the form or create a trigger on the server if that is the preferred method!?. I’m a SysAdmin with closet programming skills, so I don’t know the best way to do it… any help is greatly appreciated!!