How to create a certain Array

[bloukopkoggelmander]

Hi all

Right I have a form where a user can make a selection from about 5 radio buttons ( only one option selectable) and also another part on the form where a user can select from about 10 tickbox options( all 10 options selectable).

So when the user makes a selection forn the of any one of the first 5 radio buttons, I want that selection saved to a table once the user clicks on a save button on the form.

The same principle goes for the 10 tickboxes.

I have thought of using an Array for this, but can't get my head around how I would write the code for this to accomplish the above. Then again, an Array might not be the right option here.....

I hope this makes sense. I am using Access 2007.

Thanks

[ADezii]

Hi all

Right I have a form where a user can make a selection from about 5 radio buttons ( only one option selectable) and also another part on the form where a user can select from about 10 tickbox options( all 10 options selectable).

So when the user makes a selection forn the of any one of the first 5 radio buttons, I want that selection saved to a table once the user clicks on a save button on the form.

The same principle goes for the 10 tickboxes.

I have thought of using an Array for this, but can't get my head around how I would write the code for this to accomplish the above. Then again, an Array might not be the right option here.....

I hope this makes sense. I am using Access 2007.

Thanks

1. When you say radio buttons, are you referring to Option Buttons?
2. When you say tickboxes, are you referring to Check Boxes?

[bloukopkoggelmander]

Hi there ADezii

Yes sorry, that is correct. ( I am so used to using my own terminology )