Results 1 to 2 of 2
  1. #1
    tcheck is offline Competent Performer
    Windows 7 Access 2007
    Join Date
    Nov 2010
    Posts
    131

    Access Requery of underlying Form

    This seems pretty simple but I would like to select a combo box and after the user selects the combo box (Which Is a City) I want to use the underlining query of the form to run because I am using the <>False Criteria for a command of;



    IIf([Forms]![frm_Deals]![CheckCity]=True,[City] Is Not Null Or [City] Is Null,[City]=[Forms]![frm_Deals]![SelectCity].[Value])

    I may have other combo boxs with other information so that is why I want to run the underlying query. I have used the After Update command of;

    Me.RecordsetClone.FindFirst "[XXXX] = '" & Me!FindXXXX & "'"

    But I want to requery the query under the form. Hope this makes sense.

  2. #2
    hertfordkc is offline 18 year novice
    Windows XP Access 2007
    Join Date
    Mar 2011
    Posts
    481

    Two questions

    Quote Originally Posted by tcheck View Post
    This seems pretty simple but I would like to select a combo box and after the user selects the combo box (Which Is a City) I want to use the underlining query of the form to run because I am using the <>False Criteria for a command of;

    IIf([Forms]![frm_Deals]![CheckCity]=True,[City] Is Not Null Or [City] Is Null,[City]=[Forms]![frm_Deals]![SelectCity].[Value])
    Is this giving you the value you expected? Without context, I'm mystified by it.
    I may have other combo boxs with other information so that is why I want to run the underlying query. I have used the After Update command of;

    Me.RecordsetClone.FindFirst "[XXXX] = '" & Me!FindXXXX & "'"
    Might not onClick--- Me.Requery work?
    But I want to requery the query under the form. Hope this makes sense.
    -------------------------------------------------------------------------------------
    Hope this helps.

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

Similar Threads

  1. Out of Memory + Form requery
    By jgelpi16 in forum Programming
    Replies: 4
    Last Post: 07-20-2011, 12:41 PM
  2. Requery a form with new criterior
    By nostr4d4m in forum Programming
    Replies: 5
    Last Post: 04-05-2011, 08:57 AM
  3. Access novice help with refresh/requery
    By cvacgreg in forum Access
    Replies: 3
    Last Post: 02-04-2011, 08:51 PM
  4. underlying form prints instead of report
    By usmcgrunt in forum Reports
    Replies: 1
    Last Post: 09-17-2010, 05:22 AM
  5. Replies: 2
    Last Post: 08-26-2009, 10:43 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