How to convert multiple drop down list to just checkboxes

[Zak14]

I've got a field in a table that is a multiple drop-down list.

In the form, I don't want it to be a drop down list,
but I want the options in the drop down list to be checkboxes instead (not within a drop down).

 

[Old Man Devin]

Going to be very difficult if you want to have the options available be dynamic in the same way a drop down menu is. First you should ask yourself why you need it like this, as if doing this is even possible, I expect it will be very difficult if I'm understand you right. Might be quicker to think of another way or stick with drop-downs.

 

[CJ_London]

You can probably do this by using a subform in continuous form mode with a disconnected ADO recordset for its recordsource to provide the checkbox value and the description for the checkbox.

You will need some code to populate the recordset and then to update your table field when changes are made.

Search on line for ado disconnected recordsets - here is a link to get you started

http://www.4guysfromrolla.com/webtech/080101-1.shtml

Not sure what you mean by ' multiple drop-down list' but if you are using a multi value field in your table (sounds like you are) you may find you will need to change this since they will not translate as such to ADO.

 

[BlueIshDan]

You could also build a subform through code or edit your current form through code before loading it. But that is probably the most difficult approach.

 

[Zak14]

Nevermind. There's too much labour involved in doing this. It's not that important; just would've made for a better layout. Thanks anyway.