how to add an existing record to another table

J

James

I've two forms in my DB and I want to update ID number in Form B
automatically when I enter a new ID number in From A. How can I do it?
 
J

J. Goddard

Provided both forms are open, in the after update procedure of the
Id_Number control in Form A put :
Forms!formB![Id_number] = me![ID_Number]

John
 
Top