Subform with dropdowns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need assistance creating a subform that will allow a drop down menu and can
select more than one item from the drop down. I have created this in the
table, but can't seem to creat it in a subform connected to the main form.

Any assistance would be appreciated. Also, I do not know SQL code.
Thanks!
Krista
 
Krista,

Do not create drop-downs in the table. They are the cause of more problems
that they're worth.

Drop-downs are an excellent data selection method, but use them on forms,
not tables. In forms, they're called Combo Boxes.

Regards,
Graham R Seach
Microsoft Access MVP
Canberra, Australia
 
Hi Graham,

How can I create a subform in Form that has dropdowns that allow more than
one selection item in a dropdown. I want employees to be able to multiple
items from a drop down menu in a subform.

Thanks!
Krista
 
Krista,

Use a ListBox instead. They don't drop down, so their height property has to
be greater, but they are the only control that allows multiple selection.
Once selected, use the SelectedItems collection to retrieve the selections.
The Online help is a good place to start.

Regards,
Graham R Seach
Microsoft Access MVP
Canberra, Australia
---------------------------
 
Back
Top