Results 1 to 4 of 4
  1. #1
    sh3p is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2015
    Posts
    7

    Broken Form/Dynamic Query Help


    I have a navigation form I am using, and many of the navigation subforms have combo boxes which limit selections or query information based on previously entered values. In particular, I have a dynamic query set up that reads a 'from' and a 'to' date (unbound date picker fields) and queries the records in between those two dates for display on the same form. Last night I changed the overall layout of the navigation form (how it looks only), but didn't modify any of the queries, add any new items or change relationships in any way. Today, no matter what I do, those dynamic queries will not read the value from those date fields. If I manually enter the information, the query runs fine. Can anyone point me in the direction to figure out how this happened or where to go to investigate further?

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,726
    You have shown us no code or examples.
    How about posting your database so readers can see what you are doing etc?

  3. #3
    sh3p is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2015
    Posts
    7
    Well I can't explain it...but I was doing as you suggested, and I saved a copy of my database to remove personal information and post it here. When I saved the new copy and opened it, all the dynamic queries are magically working again.

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,726

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Broken Query
    By ThatSkepTicGuy in forum Queries
    Replies: 3
    Last Post: 09-25-2012, 09:43 AM
  2. Broken Query
    By lkevinc42036 in forum Access
    Replies: 9
    Last Post: 08-06-2012, 09:29 AM
  3. Dynamic Query Critiera: Form Name
    By tylerg11 in forum Forms
    Replies: 1
    Last Post: 06-25-2012, 11:27 AM
  4. Dynamic Form, Dynamic labels/ captions?
    By JFo in forum Programming
    Replies: 15
    Last Post: 10-12-2011, 08:33 PM
  5. Update query has broken
    By eskapades in forum Queries
    Replies: 1
    Last Post: 07-11-2011, 03:52 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums