automatic field population

  • Thread starter Thread starter Lauren B
  • Start date Start date
L

Lauren B

I have a form (Form A) where the user enters customer information that
exists on one table (Table A). Each customer is assigned a customer ID. I
have command button that opens another form (Form B)that contains some
additional information that exists on a different table (Table B)--I have
this for set as a popup.

Is there any way for me to code the event procedure so that when the users
enters the supplemental information in Form B, the customer ID entered on
Form A (essentially Table A) will populate the customer ID field (set as a
foreign key on Table B) on Table B?

Thank you in advance for any assistance.

LB
 
Assuming Form B is opened by Form A, use the OpenArgs option to pass the
customerid when you open Form B. You will also have to build logic in Form B
that will retrieve the additional information if it exists, or create a new
record if it does not.
 
Back
Top