Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Mar 2002
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Forms and tables & adding data (2000)

    I have a simple data base with 3 linked tables and a form to enter data into all three. But the form will not allow me to update the tables. I have a few combo boxes but otheriwse it is a very simple data base and I need to update the tables ith a form so I can view all the data at once. What have I done wrong?? <img src=/S/igiveup.gif border=0 alt=igiveup width=31 height=23>
    Attached Files Attached Files

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Forms and tables & adding data (2000)

    If you keep the table structure you have, then "Datelastawarded" needs to be on a subform because you can have mutlple dates for the one award. If there is only 1 date last awarded, put this stuff in the same table. When you put data in the "datelastawarded" field (with your current form), you are creating a record in the "Datelastawarded" table, but not putting any data in the "ID" field that links back to the other table. A subform will do that automatically.
    Again, if there are multiple sponsors for an award put that info in a subform.
    Regards
    John



  3. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Forms and tables & adding data (2000)

    I agree with John's comments - a subform would be the better approach with the 1 to many table. As to why the form won't update, if you set the Recordset Type property for the form to be Dynaset with inconsistent updates, it will work. We don't generally recommend that, but in this situation you may want to use it temporarily until you redesign the form.
    Wendell

  4. #4
    New Lounger
    Join Date
    Mar 2002
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Forms and tables & adding data (2000)

    Thanks! <img src=/S/joy.gif border=0 alt=joy width=23 height=23>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •