Results 1 to 2 of 2
  1. #1
    Join Date
    May 2010
    Location
    Ohio
    Posts
    2

    Unanswered: data on form NOT writing to the table

    Greetings,
    I have an unbound listbox with a query attached to it, on the dblclick event It opens a new form and populates fields on the form with the query result fields. here is the code

    Forms!tblName!fieldName = Me!listBoxName.Column(1)

    The autonumber field on the table increments like it adds a new record however, when I close the form the new record is abandoned and it does write it to the table?
    Any suggestions on how to get the data to commit to the tables?

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    How are you closing the second form, with a native Access close button (the big X) or with a button that you've created?

    Are there controls on the second form that aren't filled in before you close it?
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

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