Results 1 to 3 of 3

Thread: Editing a Form

  1. #1
    Join Date
    May 2013
    Posts
    29

    Unanswered: Editing a Form

    I created a form where I have the persons name, and phone number with all the survey questions and comments they people have filled out. I want to be able to edit each individual record. When I try to do that, it changed all the records to information I put in one of them.

  2. #2
    Join Date
    Mar 2009
    Location
    Gatineau, Quebec Canada
    Posts
    147
    Provided Answers: 1

    More Info Needed

    You will have to provide more info. I assume, for example, that this is a form bound to a database, and that you are in the single form format. I also presume your form has "allow additions" marked "yes" in form properties.

    John S
    Aylmer, Quebec

  3. #3
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Quote Originally Posted by MTSPEER View Post

    ...it changed all the records to information I put in one of them...
    The above would seem to indicate that praxis1949 is incorrect when he said

    "this is a form bound to a database"

    The behavior you describe indicates that the Controls are, in fact, Unbound. The current data in an Unbound Control, on one Record, is the current data in that Control, for all Records! That's how Unbound Controls work! You need to Bind the Controls to Fields in a Table in order for the data to be Record-appropriate.

    Linq ;0)>
    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
  •