Multiple Selection Comb Boxes

F

Fie

I have a combo box that allowes multiple selections only problem is
that it does not save the values in the Tools field in my table. How
can i get them to save
 
J

John Vinson

I have a combo box that allowes multiple selections only problem is
that it does not save the values in the Tools field in my table. How
can i get them to save
Click to expand...

Do you mean a (multiselect) Listbox? Combo boxes do NOT have a
multiselect capability.

If you are trying to save multiple values into a single Tools field...
don't. That's a misuse of Access as a relational database. You may
need another Table to resolve the many to many relationship between
your current table and the Tools table (ToolsUsed perhaps?), and use a
Subform to enter the tools used on a particualar job.

John W. Vinson[MVP]
 
F

Fie

thanks thats totally helped..


John said:
Do you mean a (multiselect) Listbox? Combo boxes do NOT have a
multiselect capability.

If you are trying to save multiple values into a single Tools field...
don't. That's a misuse of Access as a relational database. You may
need another Table to resolve the many to many relationship between
your current table and the Tools table (ToolsUsed perhaps?), and use a
Subform to enter the tools used on a particualar job.

John W. Vinson[MVP]
Click to expand...
 
Top