Error 2427: I have four radio/option buttons, and I am using office 2010

[Uunona]

I am getting error 2427 but cant trace where I am wrong. Below is my code.

Private Sub CmdCalc_Click()
Dim Area As Integer
Dim Lenght As Integer
Dim Breadth As Integer
Dim Base As Integer
Dim Radius As Integer
Dim pi As Integer
pi = 3.142
 
If OptCircle.Value = True Then (THIS IS WHERE THE ERROR IS)
InputBox ("enter radius")
Radius = intInputbox
Area = pi * Radius * Radius
LblAnswer = Area
 
End If
 
End Sub

[TheSmileyCoder]

Hi and welcome to Bytes.
When posting errors always post both the error number as well as the error description.

At the very top of your module, you will likely see written:

Option Compare Database

Below that line add:

Option Explicit

And then try to compile your project, and see what errors appear. I spot a few undeclared variables such as intInputbox which is neither declared nor assigned anywhere.

If lblAnswer is truly a label then you need to know that you cannot assign values to labels. To change labels you need to access the Caption property.

Me.LblAnswer.Caption=Area

I find that always using Me. syntax when using controls on the form makes it easier to read the code, and avoid mistakes.

Post back with the error description, and maybe I can guide you further.

[zmbd]

OptCircle.Value=true
I am guessing that this is an option button?
I am guessing that you have a series of option buttons in a group box?
If both are true (even if it is just one option button inside the group box) the the option buttons no-longer have a value... instead the group box takes the value of the positional number of the option button within the group box.

[ADezii]

Are you specifically using Access 2010?

[NeoPa]

Please start at Before Posting (VBA or SQL) Code. It saves everyone time and energy.

Now, you probably need to understand that Integer variables will not hold Real numbers. Line #8 then is a problem.

I suggest you fix all of the really basic problems already mentioned then come back to us, if you are still having issues, with the new code and a properly explained problem.