bound object Frames - I need help!!!

[scollins]

I want to use a bound object frame and put 3 option buttons in this frame. I then want to say if this option button is checked update the rst with a value of true and if this optino button is checked, update the rst with a value of true etc. However, I want the users to only have the ability to check one box and when they do check the box, the rst will be updated.

Any suggestions...

Thank you

 

[jebry]

Hi!

You don't want the bound object frame control, you will need to use the option group. If you put your check boxes in an option group then Access will allow the user to check only one of the group and the value of the option group will be equal to the option value of the box checked.

hth Jeff Bridgham
bridgham@purdue.edu

 

[scollins]

So when I code it to populate the recordset do I say
if me![name of option button or option group?].value = true (or do I put the actual value I gave each box in the properties) then
rst.edit
rst![vtd1].value = true
rst.update

Thank you!

 

[jebry]

Hi again!

Most programmers would probably use a Select statement:

Select Case YourOptionGroup.Value
Case 1(or whatever you used)
rst.edit
rst![vtd1].value = true
rst.update
Case etc.
Case Else
Call MsgBox("You must select one of the options."
End Select

hth
Jeff Bridgham
bridgham@purdue.edu