confused in control array of option buttons

hi,
i have 4 option buttons in 1 frame & option buttons are in control array. i want to store caption of option button in database. when i write dbfield=optionbutton(0).caption then it stores only opt. button's 0'th index field. so plz help me out to save either of captions amongs 4 opt. buttons.

I don't understand your problem but

optionbutton(0).caption
optionbutton(1).caption
optionbutton(2).caption
optionbutton(3).caption

this will give all the four captions

you would need to concatenate the fields into one db field, or use 4 fields.

use

Code:

---

optionbutton(0),optionbutton(1),optionbutton(2) And optionbutton(3)

---

or for the first choice,

Code:

---

optionbutton(0) & " / " & optionbutton(1) & " / " & optionbutton(2) & " / " & optionbutton(3)

---