Results 1 to 8 of 8
  1. #1
    jtakajr is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2020
    Posts
    4

    Filter List Box with Combox Box Value inside form

    Hi there!



    I'm trying to make a form that shows all previous attendance entries for an employee ID number (chosen by a combo box) while the user completes the form for reference.

    Form: Attendance Log1
    Combo Box: Combo20
    List box: List144
    Table: Attendance Log
    Employee ID Column Header in table: EmployeeID


    Thank you!

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    49,855
    Apply filter criteria to AttendanceLog1

    Review http://allenbrowne.com/ser-62.html
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    jtakajr is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2020
    Posts
    4
    Hmm.. that doesn't seem to help me. any other recommendations?

  4. #4
    jtakajr is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2020
    Posts
    4
    Hmm.. that doesn't seem to help me. any other recommendations? 

  5. #5
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    49,855
    "Doesn't help" means what - error message, wrong result, nothing happens? Exactly what did you try? If you want to provide db for analysis, follow instructions at bottom of my post.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  6. #6
    jtakajr is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2020
    Posts
    4
    I'm working on two things: on the "landing page" a current month birthday list, and on the attendance log form - a list of all the previously submitted attendance entries for the employee ID selected in the combo box.
    Attached Files Attached Files

  7. #7
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    49,855
    Sorry, I cannot open db because I only have Access 2010. Yours must be using some feature requiring later Access.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  8. #8
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    7,501
    1) I don't see why you're using a split form for this. Perhaps your db sample doesn't really reflect what this is for?
    2) you should turn on "require variable declaration" then go back to your existing code and add Option Explicit under Option Compare, or you deserve all the undeclared variable grief you get! I cannot for the life of me understand why this isn't an MS default.
    3) I'm going to guess that it doesn't work for you because it (listbox) is unbound and you never requery it. I would try that on the form Current event:
    Me.combo20.Requery
    4) I suggest you do not have special characters (save perhaps underscore) in any object name (e.g. Attendance Log1)
    Last edited by Micron; 10-17-2020 at 09:39 PM. Reason: clarification
    - "doesn't work" doesn't help. Implement changes in copies of your database.
    "Everyone has a photographic memory; some just don't have film." Steven Wright

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

Similar Threads

  1. Replies: 1
    Last Post: 05-06-2019, 10:27 AM
  2. Filter report inside a form
    By aceSoft in forum Access
    Replies: 1
    Last Post: 04-15-2017, 08:14 AM
  3. Combox list box
    By tmcrouse in forum Forms
    Replies: 2
    Last Post: 04-28-2014, 06:49 PM
  4. Combox box Item List
    By engr_saud1 in forum Access
    Replies: 1
    Last Post: 04-04-2013, 06:50 AM
  5. Replies: 5
    Last Post: 03-15-2013, 10:53 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 - Senior Forums