Changing a drop down box to radio buttons

[Pharma Down]

Hi

I have a risk matrix (Johari window) that I would like to make 'selectable' in a form, rather than having to select an item from a drop down box. Ie, I have a 5x5 grid (25 box grid) - A,B,C,D,E on one axis and 1,2,3,4,5 on the other: potential options to select are A1, A2, A3, A4, A5, B1 etc - I'd like to be able to have a form user click a radio button in one of the boxes rather than slect an option from a drop down list. Is this possible? I this possible?

Andy

 

[boblarson]

Possible, but a pain to manage. You would need to use

1. Single Form View Only.
2. The option (radio) buttons are left unbound.
3. In the form's On Load and On Current event you would need code to pull the values from the table and make the applicable options display what had been chosen.
4. In the form's Before Update event you would need to run code to insert or update the values in the table (if multiple options are selectable, then it would require a separate table with the PK of the record and the option selected and there would be a record for each option selected.

If you are not an intermediate to advanced user with VBA, this might be quite challenging to actually pull off.

 

[Pharma Down]

That explains why I haven't been able to manage it!

I guess that this might be a project for another time and I'll have to make do with the drop down list.

Thank you

Andy