I have a form that we use for data entry and it has a combo box lookup for Builder's name. In the builder lookup table I have Builder Name, salesman, contact, phone, and a few other fields. When the builder field is updated on the form, I want the form to get the three other corresponding fields from the builder lookup table and populate the form so the data can be stored in my Project_TBL.
I need to store the data in the Project_TBL and not just associate builder name in Project_TBL with builder name in the lookup table because the salesman and the other fields can change over time and I need to be able to look back and see who was the salesman a year ago and not just the current salesman assigned to the builder.
I know I need to use the After Update Event Procedure but I am unsure how to write the code.
Any help would be appreciated.
Thanks JRM
I need to store the data in the Project_TBL and not just associate builder name in Project_TBL with builder name in the lookup table because the salesman and the other fields can change over time and I need to be able to look back and see who was the salesman a year ago and not just the current salesman assigned to the builder.
I know I need to use the After Update Event Procedure but I am unsure how to write the code.
Any help would be appreciated.
Thanks JRM