Table not saving records

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • tmdrake
    New Member
    • Mar 2013
    • 43

    Table not saving records

    My form has text and combo boxes that are bound to a table. Upon completion of one entry that infor is saved to table, however when you go to enter the next record, the information from the previous record disappears from the table. I'm not getting error on the form, so I assume everything is working. Please help,for I'm losing information.

    Thanks
  • slenish
    Contributor
    • Feb 2010
    • 283

    #2
    What you might want to try (if you dont have it already) is add a button on the form that has to be pressed to save the record. In the OnClick event add in
    Code:
    DoCmd.GoToRecord,,acNewRec
    or
    Code:
    DoCmd.GoToRecord,,acNextRec
    .
    Last edited by zmbd; Mar 27 '13, 08:27 PM. Reason: [Z{Please use the [CODE/] button to format posted code/html/sql - Please read the FAQ}]

    Comment

    • zmbd
      Recognized Expert Moderator Expert
      • Mar 2012
      • 5501

      #3
      tmdrake:
      What if any code to you have behind the form?
      Especially an code behind the combo boxes.

      And just because I have to... have you actually opened the table that the form/controls are bound to to see if the data is actually there and not being shown for some reason?

      The next thing is to check that the control source and the bound properties for the controls is set properly.

      Comment

      Working...