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

    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.

    ie.

    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
    Location
    Kentucky
    Posts
    496
    Provided Answers: 24
    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
  •