Scope of Variables

Local Variables

Global Variables

Persist Values of Variables

Simple Variables

Constant Variables

Static Variables

Object Variables

mainipulate object of databases by assigning object to variables.

'load the form first
    Dim saleOrders As Form
    Set saleOrders = Forms("Sale Orders")
        MsgBox saleOrders.Name
    Set saleOrders = Nothing
Private Sub Volume_GotFocus()
Dim frm As Form, vol As Integer, uomId As Integer, uomControl As TextBox

' Set uomControl = Forms!orders.UOM
Set uomControl = Me.UOM
uomControl.Value = 3

End Sub
Nelson Bighetti
Nelson Bighetti
Professor of Artificial Intelligence

My research interests include distributed robotics, mobile computing and programmable matter.