Hi
I know this will be something simple to someone out there.
I have a form for craeting a new project, the data entered on the form should save to the tblProjectsDetails only the following are saving
ProjectNo
ProjectName
OrderNo
QuotedAmount
CompanyName
The remaining text boxes on the form are auto populated by a combo box which gets its data from tblCompanyName. When the company name is selected the following data populates the text boxes.
Company Address
CompanySuburb
CompanyPostcode
CompanyContact
CompanyTelNo
CompanyFax
CompanyEmail
All this imformation shows on the form but only the following saves to the table
ProjectNo
ProjectName
OrderNo
QuotedAmount
CompanyName
I have checked the properties of the combo box and it is bound
In the Control Source of each CompanyField is
CompanyAddress: =CompanyName.Column(2)
CompanySuburb: =CompanyName.Column(3)
and so on for the other text boxes