Results 1 to 5 of 5
  1. #1
    rlbroerman
    Guest

    multiple value list box (access 2007)

    Can anybody help with this, please?
    I am trying to add a multivalue list box to frmPatients. I want this list box to save multiple values. See my attempt in the lower right hand corner of “frmPatients”
    I found a way to do this in the Access help under “Add or change a lookup column that lets you store multiple values” I want this to look like sample shown in thr Help.
    My list of possible pain levels is in the table “tblPainLevel” and the table I want to store the list of pains is in “CurrentPain”
    The part that doesn’t work like I thought it should is found in
    Add or change a lookup column that lets you store multiple values
    Then
    Using the Lookup Wizard to create multivalued lookup columns
    Then
    7. Under Do you want to store multiple values for this lookup?, select the Allow Multiple Values check box.
    The above doesn’t appear in the Wizard.
    The beginning of the help says this is new in Access 2007.
    Do I need to turn something on to make this work?
    Or should I do something completely different?
    Thanks for the help.
    Rick B
    Attached Files Attached Files

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: multiple value list box (access 2007)

    Why are you using a listbox? This should be a subform.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  3. #3
    rlbroerman
    Guest

    Re: multiple value list box (access 2007)

    Mark,
    Did you see the example in the "Help"?
    The list box with the check boxes for each "pain" seems like a very good way to do it.
    Thanks
    Rick B

  4. #4
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: multiple value list box (access 2007)

    It just seems to me that a subform would be easier to deal with. There would hardly be any coding needed.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  5. #5
    rlbroerman
    Guest

    Re: multiple value list box (access 2007)

    Mark
    Maybe so, but I would like to try the list box with check boxes to save multple items.
    Rick B

Posting Permissions

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