Form information as a variable in VBA

[mahmud1180]

I am struggling to use the form data as a variable in my VBA code. Like if I put in the form a text box that has 'variable1 1', in VBA code it will appear as variable1=1. Is it possible? I have tried several ways like bang operator but it did not work. Thanks in advance.

[June7]

Certainly can reference form controls. A textbox named tbxQuantity could be referenced like:

If Me.tbxQuantity > 0 Then
...

[mahmud1180]

Thank you June for your quick reply.

Private Sub Command2_Click()




If Me.Contract1 = 1 Then
Firstcontract = 5
Else
Firstcontract = 0
End If

MsgBox (Firstcontract)
End Sub

I put it like that but when I ran the command button it says : compile error( Method and data are not found).

Do I need to put anything else inside the subroutine or change the properties of the text in the form?

[ItsMe]

Maybe you can declare a variable to hold the value of your result. Here I use type double but you may be able to use another data type, string, integer, long, etc.

Dim dblFirstcontract as Double

If Me.Contract1 = 1 Then
FdblFirstcontract= 5
Else
dblFirstcontract = 0
End If

MsgBox (dblFirstcontract)

[June7]

Which line causes the error?

Even without explicit declaration of variable, the code should work. Every code module should have the following two lines in module header:

Option Compare Database
Option Explicit

The second line will require all variables to be declared.