Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2016

    Unanswered: Filter List based on row value

    Apologies if is simple but has me stuck last few days. New to access so may be something I'm missing.

    Trying to create a drop down list that is filtered based on previous field in table row. ie, what AEattendance the clinic list applies to but only show attendances relating to that patient.


    Table1 - AEattend

    AEDepartmentRef (primarykey)
    PatientNHSFK (uniquefk)

    table2 - AmbCareAttend

    AmbCareRef (PK)
    PatientNHSFK (uniquefk)
    AEDepartmentRef (foreignkey) (this one to be a list box but only display attendances related to previous patientnumber)

    Currently the list shows attendances for every patient. If put criteria under list of =[AmbCareAttendence]![PatientNHSFK] will ask for the number but then lock it in for the rest of the inputs in table.

    Cheers for your help.

  2. #2
    Join Date
    Apr 2014
    Provided Answers: 35
    You filter items on the CURRENT record. The current record cannot see the previous record.
    Youd have to write code.

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