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

    Changing the Control Source of a Form (2007)

    I have been irritated today by an Access 2007 bug , that I have not seen mentioned here before, although it is documented elsewhere (e.g. Allen Browne ).

    If the source for a form/report is a SQL statement, and you click the Build button beside the RecordSource property, your changes are <font color=red>lost</font color=red> when you return from the query designer (unless you explicitly move the cursor to another property in the properties box.)

    I have had this problem before, but I forget about it. Then when it starts happening next time, I think I must have done something wrong. Hopefully, making this post might help me to remember.
    Regards
    John



  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Changing the Control Source of a Form (2007)

    Curious! Access 97 had this bug - changes to properties had to be 'confirmed' by clicking in another property before saving the database object, otherwise they would be lost. This problem didn't occur in Access 2000-2003.

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Changing the Control Source of a Form (2007)

    I have noticed a somewhat similar problem with A2003. I don't think it is a question of not remembering the changes, it is just that the changes (that is, new fields) may not be immediately recognized by Access, so you may not seem them on the field list. I've just gotten into the habit of tabbing to the next property after returning from changing the SQL.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

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