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!?. Im a SysAdmin with closet programming skills, so I dont know the best way to do it any help is greatly appreciated!!