Results 1 to 2 of 2
  1. #1
    deepakg27 is offline Competent Performer
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2017
    Posts
    160

    How to update sub-query inside a form based on the parameters changed in the main form

    Hi Guys,

    I am working with a simple production database. I have built a form in which customer selects the month and in a sub form Or Sub query the results are displayed. The query is getting the results based on Sdate & Edate user input variables. Query is working fine.



    My problem is as I update the value in user input boxes, the sub-query on the form does not update. I have tried running me.requery on field update procedures but it just works for the first time (when I add the code). Sorry when ever Shifting from form view to design view & back to form view the Subquery updates and works fine. Just need to do it without going into design view and come back.

    How can I do this. Please help and guide.

    Thanks and regards
    Deepak Gupta

  2. #2
    deepakg27 is offline Competent Performer
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2017
    Posts
    160
    Got it to work. Used refresh command.

    thanks

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

Similar Threads

  1. Replies: 17
    Last Post: 05-17-2017, 11:59 AM
  2. Replies: 14
    Last Post: 06-13-2014, 04:29 AM
  3. Replies: 5
    Last Post: 11-13-2013, 10:02 AM
  4. Replies: 4
    Last Post: 10-24-2013, 12:32 PM
  5. Replies: 14
    Last Post: 03-07-2012, 03:46 AM

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