can someone tell a macro code that does the following
on event procedure for this specfic field

i would like form field (a) data to go to 2 different tables when the user clicks add record

further note
the form is made on table (A) andthere is a column in table called (a1) "form field a is made from table field a1 "
there is a 2nd table called (B) with a column named (a1) "relationship"
data (a) comes fromt the field (a1)

i want (a) to go to both of these tables

Read up on data normalization! Not a good idea to duplicate data. Just more work if it changes!