Recent content by afia

  1. A

    How to create multi value select in access form and add values in database table

    Thank you so much for explaining in detail and helping.
  2. A

    How to create multi value select in access form and add values in database table

    thank you for explaining. I will try it out but i think i am a but clueless on this.🤦‍♀️
  3. A

    How to create multi value select in access form and add values in database table

    😬. Criteria as in the Form properties?
  4. A

    How to create multi value select in access form and add values in database table

    It is the continuation of my post and I have provided all the details above .MajP and GaP42 has provided advise on cascading forms but i am struggling a bit on it. The subcategory is not linking up with the Category. For example, If i select Injury category Hand, Subcategory should only show up...
  5. A

    How to create multi value select in access form and add values in database table

    I have tried everything but still unable to successfully create synchronized subcategory. If i select a category, it does show subcategories but all of them and not the specific ones. I have attached access db for reference if can help please
  6. A

    How to create multi value select in access form and add values in database table

    The duplicate value issue is resolved. Only thing left is in subform is that its not showing up injury description. Even if i add the column it only lets me select the options from drop down InjuryID_FK and not from description
  7. A

    How to create multi value select in access form and add values in database table

    Thats right we can receive multiple referral for one patient in a year. I don't need to keep a record of all appointment, it would be just one column of no. of appts. I have tried to create a subform but comes up with an error when i try to add multiple values as shown below: Below is the...
  8. A

    How to create multi value select in access form and add values in database table

    and what do you recommend how shall i add this NAture of Injury field on the form?
  9. A

    How to create multi value select in access form and add values in database table

    Thank you. How shall i add on form? in the form of list?
  10. A

    How to create multi value select in access form and add values in database table

    I have a design a form in which i have below fields: First name, Surname, Dob, Age, Gender, Referral reason, Work Pattern, Priority , Treatment location, Initial Appointment date, Discharge date, intervention, Nature of Injury. For "Nature of Injury", user can select multiple values for...
Back
Top Bottom