set option button to true

[crowegreg]

On a form I have 10 option buttons. Named option1, option2, option3..

If I create a recordset which the contains the option buttons I would like set to true, what is the sytax for setting that option button to true?

An example, if my recordset returns the following:
option3
option7


option9

Normally I would just use the command me.option3=true. What's the syntax within the loop for setting those options to true?

[Missinglinq]

Me.Option3 = True or Me.Option3 = -1 should both work, although I always use the latter. Don't remember the whys and wherefores, but there are some situations where the former confuses the Access Gnomes!

But I'm not exactly sure of what your question is here!

...If I create a recordset which the contains the option buttons I would like set to true, what is the sytax for setting that option button to true?

...What's the syntax within the loop for setting those options to true?

What loop? What, exactly, are you trying to do here?

Linq ;0)>

[crowegreg]

I found the solution on another board. Here's my solution
Me.Controls("Option" & stra0) = True

The variable stra0 has been assigned the record from the recordset