Two Forms and Two Fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Having looked at the nothwind sample database re orders I want to create a
similar event such that when a company is selected from a dropdown the
address is filled in automatically. I have created 2 Tables add_master &
invoice and two forms add_master_ip and invoice_ip. On the form invoice_ip I
have a combo box called “company_name†which successfully reads the correct
field from add_master.
From the combo box I am running a script (after up date) as follows:-

Private Sub company_name_AfterUpdate()
Me!company_name = Me![company_name].Column(1)
Me!inv_add1 = Me!add1
Me!inv_add2 = Me!add2
Me!inv_add3 = Me!add3
Me!inv_postcode=Me!postcode
End Sub

The fields add1 exist within the tables add_master and should be passed to
the tables invoice. The script will not run as I think it can not see the
table add_master.
I missing something and maybe a lot

Thank You
 
First it seems that your inserting data into fields on the same form.
Your first line Me!company_name = Me![company_name].Column(1) is
pulling data from the same field. Both are the same name. Now if you
are using two seperate forms then you need to full sytax. Example:
Forms!FormName!ControlName = Forms!FormName2!ControlName
The word "Me" refers to the current form only.
 
Back
Top