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