Results 1 to 2 of 2
  1. #1
    allykid is offline Novice
    Windows XP Access 2003
    Join Date
    Jul 2010
    Posts
    22

    List box update from combo box choice

    I have a combo box that should populate a list box based on the selection. If I run the query outside the form it works like a parameter query and it returns the correct results.

    Here is the VBA that I have attached to the form:

    Prive Sub Form_Current()
    Me.lbEntitlements.Requery
    End Sub

    Private Sub cbAllSystems_AfterUpdate()
    Me.lbEntitlements.Requery
    End Sub



    Still very green in regards to Access and VBA... any thoughts.

  2. #2
    MWMike is offline Novice
    Windows XP Access 2007
    Join Date
    Sep 2010
    Location
    Long Island, NY
    Posts
    18
    Try changing

    Private Sub cbAllSystems_AfterUpdate()
    Me.lbEntitlements.Requery
    End Sub

    to:

    Private Sub cbAllSystems_Change()
    Me.lbEntitlements.Requery
    End Sub

    I would google some help on Events in VBA

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

Similar Threads

  1. How do I put a multi-choice option on my form?
    By Dollydriver in forum Forms
    Replies: 13
    Last Post: 02-09-2011, 05:40 PM
  2. Combo box for list
    By Danzig in forum Forms
    Replies: 6
    Last Post: 11-03-2010, 05:18 PM
  3. populate boxes based on combo box choice
    By Mattm1958 in forum Forms
    Replies: 13
    Last Post: 08-30-2010, 02:09 PM
  4. Update Field list in Table with Query
    By Scorpio11 in forum Queries
    Replies: 3
    Last Post: 07-16-2010, 01:57 PM
  5. combo box value list
    By thewabit in forum Forms
    Replies: 13
    Last Post: 01-13-2010, 07:50 PM

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