Results 1 to 3 of 3
  1. #1
    AUS1960 is offline Novice
    Windows Vista Access 2003
    Join Date
    May 2011
    Posts
    4

    Red face Data Not Saving To Table

    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

  2. #2
    khalid's Avatar
    khalid is offline MS-Access Developer
    Windows XP Access 2007
    Join Date
    Mar 2010
    Location
    Kuwait
    Posts
    244
    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.

  3. #3
    AUS1960 is offline Novice
    Windows Vista Access 2003
    Join Date
    May 2011
    Posts
    4
    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.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 04-19-2011, 01:55 PM
  2. Replies: 23
    Last Post: 02-09-2011, 10:56 AM
  3. Saving data
    By mwabbe in forum Access
    Replies: 1
    Last Post: 09-09-2010, 11:18 AM
  4. record saving twice in table
    By ds_8805 in forum Forms
    Replies: 15
    Last Post: 04-14-2010, 07:16 PM
  5. Saving forms as Data Access Pages
    By frowsyone in forum Access
    Replies: 1
    Last Post: 03-08-2010, 08:25 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums