Results 1 to 2 of 2
  1. #1
    Access_Novice is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Sep 2013
    Posts
    265

    How did this requery work?


    I'm on the form called frmMembership. Based on selecting a parent name, only their kids would appear in the gymnast combo box. The code that I have does just that so it gives me just what I want. What I can't understand is how this worked.

    Code:
    Private Sub parent_AfterUpdate()
        Me.gymnast.Requery
    End Sub
    This form is based on the table 'Membership.' I know both values appear in membership now, but the filtered values in the gymnast combo box still appeared even before the first row of data was entered.
    Attached Files Attached Files
    Last edited by Access_Novice; 01-04-2014 at 07:17 PM. Reason: Forgot to attached database.

  2. #2
    Access_Novice is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Sep 2013
    Posts
    265
    Nevermind. I just realized that this is working because I have a query row source for the Gymnast combo box and I have a criteria filter by parent ID. Maybe it's getting too late.

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

Similar Threads

  1. Replies: 4
    Last Post: 12-31-2012, 01:10 PM
  2. Requery Report with VBA
    By tylerg11 in forum Reports
    Replies: 3
    Last Post: 07-30-2012, 10:41 AM
  3. Requery
    By Grizz2 in forum Queries
    Replies: 2
    Last Post: 05-31-2011, 10:23 AM
  4. Requery fails
    By Dega in forum Forms
    Replies: 3
    Last Post: 09-28-2010, 08:35 AM
  5. Requery?
    By CO711 in forum Forms
    Replies: 0
    Last Post: 08-06-2008, 08:03 AM

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 - Senior Forums