Data Not Saving To Table

[AUS1960]

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

[khalid]

Hi this because the combo box is pupolating the field valuse in unbound textboxes on the form.

The question is? why you want to save these values again in tblProjectsDetails table?
I wonder if your normalization of tables are properly done? the relationship of your tables should be done properly and avoid the duplication of records entries.

I suggest you should re-consider the table relationship for normalization.

[AUS1960]

What i am trying to achieve is this:

On the frmProjectDetails I have a combo box so when I select the ProjectNo from the combo box it populates the text boxes on the frmProjectDetails with all the project details including all the Company Details. I am not very experienced with Access so have built my data base from knowledge gleened from the fourms and trial and error.

I don't know how else I can get the data onto the frmProjectDetails without it being stored in tblProjectDetails.

This is why I am using the frmNewProjectDetails to enter the Project details and Company Details. I am pulling the CompanyDetails from the tblCompanyDetails.