Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2007
    Posts
    9

    Question Unanswered: How do I record sub-elements to a Combo Box selection?

    Hi Forum Members
    I need help again in solving what I am sure is a simple problem. I have a table with a field called "Issue". I want to populate the field with a selection from a combo box, eg Issue = AMA, Walk-out, Elopement, IV Infiltration etc.
    The problem I am having is with other selections from the category "Issue" that have sub-elements eg.

    Issue = Combo Box selection - Fall
    then for - Fall - was there an INJURY - Yes/No

    Also

    Issue = Combo Box selection - Altercation
    then for - Altercation - was it between Patient, Staff, Both

    Also

    Issue = Combo Box selection - Adverse Reaction
    then for - Adverse Reaction - was it - Blood, Drug, Other, (Other would have to be a memo field for comment)

    If there are no sub-elements the combo box works fine, but with the the addition of sub-elements I can't see how the combo box would work.

    The problem is I want to keep all the "Issues" together for easy reporting purposes.

    Any suggestions will be very much appreciated.

  2. #2
    Join Date
    May 2004
    Location
    New York State
    Posts
    1,178
    Try using two combo boxes, where the second combo is only called into action with a Requery in the first combo's AfterUpdate event. You may have to tinker with it, because there aren't always subs, as you mentioned. However, it is probably doable.

    Good luck,

    Sam

  3. #3
    Join Date
    Jul 2007
    Posts
    9
    Thank you Sam, I will try that.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •