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 sspatriots@yahoo.com>
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]
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic () |
Tidak ada komentar:
Posting Komentar