Please help, simple radio button code wont work and I cant work out why

A

andyj2k1

New member

Local time

Today, 09:57

Joined

Feb 25, 2007

Messages

3

• Feb 25, 2007

• #1

Hi folks. Ive got a simple bit of code saying..

Dim score As Integer
score = 0

If Option16.Value = 1 Then
score = score + 1
end if

But i keep geting an error message saying "you entered an expression that has no value"

Anyone got any ideas, this is really frustrating me now!

 

R

Rickster57

Registered User.

Local time

Today, 01:57

Joined

Nov 7, 2005

Messages

431

• Feb 25, 2007

• #2

option

the option value = -1 for true and zero for false.

OOPs, I'm thinking of a checkbox. Sorry about that.

 

Last edited: Feb 26, 2007

U

unclejoe

Registered User.

Local time

Today, 16:57

Joined

Dec 27, 2004

Messages

190

• Feb 26, 2007

• #3

Hi,

It should be "Option16.OptionValue".

This control ("Option16.Value") does not work in VBA.

You can set the OptionValue to 1,2,3...etc.

HTH

andyj2k1 said:

Hi folks. Ive got a simple bit of code saying..
Dim score As Integer
score = 0
If Option16.Value = 1 Then
score = score + 1
end if
But i keep geting an error message saying "you entered an expression that has no value"
Anyone got any ideas, this is really frustrating me now!

Click to expand...

 

RuralGuy

AWF VIP

Local time

Today, 02:57

Joined

Jul 2, 2005

Messages

13,825

• Feb 26, 2007

• #4

Andy,
Where do you have that code? Is Option16 an OptionGroup control?

 

A

andyj2k1

New member

Local time

Today, 09:57

Joined

Feb 25, 2007

Messages

3

• Feb 26, 2007

• #5

Thanks for the help guys, its just a option box (radio button) on a form. Still cant get it to work

 

U

unclejoe

Registered User.

Local time

Today, 16:57

Joined

Dec 27, 2004

Messages

190

• Feb 26, 2007

• #6

Hi,

Then, "Option.Value" should work.

"you entered an expression that has no value"

The code you gave might not come from it. Is there something else in the code? In the VBA editor, where did the line stop?

andyj2k1 said:

Thanks for the help guys, its just a option box (radio button) on a form. Still cant get it to work

Click to expand...

 

A

andyj2k1

New member

Local time

Today, 09:57

Joined

Feb 25, 2007

Messages

3

• Feb 26, 2007

• #7

Thanks for all your help!!!

Problem solved

Phew