Hi,
How can I insert the text labels of the checkboxes when they are clicked into a database. e.g. I have, 4 checkboxes with Travel, Books, Movies and Adventure in a form. When Travel and Books are checked I want those to be inserted in the Access Database like [Travel,Books] in the SAME column.
Is it possible?
I tried changing the Yes/No value of checkboxes to Textfield, but keep getting the following error:


Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Duplicate output destination 'Interests [column-name]

Thanks
Sabs

The best way around this is to make a multi-select List Box instead of a checkbox i think. This will allow you to collate the selections of the list into 1 field on the database.

Haven't tried it but in principle it should work...

------------------------
Julio Mellado

PHP | MySQL | UD4

ICQ: 19735247
MSN: