Re: Multi-Select list box on a Data Entry Form

It's possible (through the use of VBA code, since you cannot bind a field to
a multi-select list box), but it's a very bad idea, as it will be very
difficult to write queries to retrieve the information from that field.

You're far better off properly normalizing your tables, so that you've got a
parent table with the bulk of the information, linked to a child table with
one row for each selected option.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Brandon" <Brandon@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C8ED5FB7-B039-4DF8-A821-9BF7F14CB74C@xxxxxxxxxxxxxxxx
Hello,

I am wanting to place a multi-select list box on my data entry form that
allows users to select multiple options and those options will get added
into
a record with comma delimited. Is this possible? If so, how should I go
about
doing it.

I tried to create a multi-select box with the various options to choose
from, but when I choose the items it does not enter them in the table as a
record. Any assistance would be appreciated.



Thanks,
Brandon


.

Relevant Pages

  • Re: Unbound control, testing its value
    ... You sure you're referring to the correct control? ... Doug Steele, Microsoft Access MVP ... An unbound control on my form has a value of true or false ... How do I determine that value for VBA code and testing whether it is True ...
    (microsoft.public.access.forms)
  • Re: Conditional Text within Paragraph
    ... I think you'd be better off using VBA code in the Format event ... Doug Steele, Microsoft Access MVP ... but you can only join a plan " & IIf([group ...
    (microsoft.public.access.reports)
  • Re: Option Buttons for Rating?
    ... If so, bind your table's field to the option group, and the field ... Doug Steele, Microsoft Access MVP ... (no private e-mails, please) ...
    (microsoft.public.access.gettingstarted)
  • Re: MS Project - Error 429
    ... Doug Steele, Microsoft Access MVP ... (no private e-mails, please) ... I am trying to do a late bind. ... Set lvoMSP = CreateObject ...
    (microsoft.public.access.modulesdaovba)
  • Re: printing access report to the file using vba
    ... > option flag from the printer dialog. ... >> Doug Steele, Microsoft Access MVP ... >>> How do i print the access report to the file using the vba code. ...
    (microsoft.public.access.devtoolkits)
Loading