Re: [MS_AccessPros] Multivalued lookup based on a table

Steve,

I am not aware of a way to show a multi-valued combo list with check boxes.

However you can add items to the list by using the not in list event to
trigger a form to add a record to the table that is the list's row source.
I am on the road for the weekend but can give you some cod on Monday if you
still need it.

In 2010, you can use the look up wizard for a multi valued field. That may
even give you the check boxes you are looking for but I do not recommend
multi-valued fields.

Glenn

Sent from my Galaxy tablet.
On Feb 16, 2013 5:56 AM, "sspatriots" <sspatriots@yahoo.com> wrote:

> **
>
>
> Glenn,
>
> Thanks for the help. I see what you are saying and managed to get the
> multi-valued lookup in my table. Is there a way to see a multi-valued list
> with these checkboxes in a form? I'm struggling to even find much
> information on how to do this on-line.
>
> Thanks,
>
> Steve
>
> --- In MS_Access_Professionals@yahoogroups.com, Glenn Lloyd wrote:
> >
> > Steve
> >
> > I don't  know of a way to do it in the wizard but if you look at the
> properties of the combo box you should see a multi valued property.
> >
> > Glenn
> >
> >
> >
> > Sent from Samsung Galaxy Note ll Mobile Â
> >
> > -------- Original message --------
> > From: sspatriots
> > Date: 2013-02-15 9:27 PM (GMT-05:00)
> > To: MS_Access_Professionals@yahoogroups.com
> > Subject: Re: [MS_AccessPros] Multivalued lookup based on a table
> >
> > I've pretty much given up on trying to create a multivalued lookup box
> for my form that will allow the user to add entries to that lookup as well.
> >
> > However, I do want to create the multivalued lookup box for my form.
> From everything I've found, using the Lookup Wizard I should be able to do
> this. However, at the very end of going through all the steps with the
> wizard where you label your lookup field, I don't see the options to
> "Enable Data Integrity" and "Allow Multiple Values". Does anyone now of a
> setting or something I need to make in order to be able to see these
> options in the Wizard. I'm using Access 2010.
> >
> > Thanks,
> >
> > Steve
> >
> > --- In MS_Access_Professionals@yahoogroups.com, "sspatriots" wrote:
> > >
> > > Glenn,
> > >
> > > Actually what I was hoping to achieve was having a dropdown list (I'm
> guessing a combobox) on my form that has checkboxes next to everything in
> the list drops down where the user can select 1 or more of the choices, but
> also have the ability to add an entry to that list on the fly if they don't
> see what they need to see there. Or, is this not even possible. I really
> don't know because I'm quite new to Access.
> > >
> > >
> > > Thanks,
> > >
> > > Steve
> > >
> > > --- In MS_Access_Professionals@yahoogroups.com, "Glenn Lloyd" wrote:
> > > >
> > > > Steve,
> > > >
> > > >
> > > >
> > > > If I understand your question correctly, you want to have checkboxes
> on the
> > > > form for the user to check but then add checkboxes to the form if
> the user
> > > > adds new items to the list in a combo box.
> > > >
> > > >
> > > >
> > > > As long as the source of the combo box list is a table, it is
> relatively
> > > > simple to add new items to that list. What is more difficult is
> adding
> > > > checkboxes to the form. In fact if you compile the application to an
> mde or
> > > > accde, you can't add check boxes the form because that is a design
> change.
> > > >
> > > >
> > > >
> > > > Glenn
> > > >
> > > >
> > > >
> > > > From: MS_Access_Professionals@yahoogroups.com
> > > > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of
> sspatriots
> > > > Sent: February-15-13 10:27 AM
> > > > To: MS_Access_Professionals@yahoogroups.com
> > > > Subject: [MS_AccessPros] Multivalued lookup based on a table
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > Is it possible to have a multivalued lookup based on a table that
> will allow
> > > > a user filling out a form to add to that list from the form if their
> choice
> > > > isn't in the list to select a checkbox for? If so, can someone give
> me an
> > > > idea of how this is done? I need the user to be able to check as
> many items
> > > > that apply plus have the ability to add to the list.
> > > >
> > > > Thanks,
> > > >
> > > > Steve
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>


[Non-text portions of this message have been removed]



------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/