'폼의 컨트롤 소스를 주는 방법

=FirstName & " " & LastName (Displays the values in the FirstName and
LastName controls separated By a space).
=Left(CompanyName, 4) (Displays the first four characters of the value
of the CompanyName control).
=Sum(Quantity*Price) (Displays the sum of the product of Quantity And Price
fields For all the records displayed By the form).

=IIf(IsNull(Sum(Quantity*Price),0,Sum(Quantity*Price))
(Displays a zero If the sum is Null; otherwise,
displays the sum - the IIf Function is an in-line if-then-else).

=Count(EmployeeID) (Displays the number of records displayed By the
Form that have a non-Null value In the EmployeeID field).

*** Can also refer to another Open Form ***

=Forms![Customer Orders]!CustomerID
(Displays the value of the CustomerID field In the
data source of the Customer Orders form).

=Forms![Customer Orders]![Customer Orders Subform1]!OrderDate
(Displays the value of the OrderDate Control of the current
record In the Customer Orders Subform1 subform of the Customer Orders form).

=[Orders Subform]!UnitPrice (Displays the value of the UnitPrice Control of the current
record In the Orders Subform of the active form. The
calculated Control is located On the main form).

=Parent!OrderID (Displays the value of the OrderID Control On the parent
Form of the current subform. The calculated Control is
located On the subform).

= "The Customers current record is " & Screen.ActiveForm.CurrentRecord & " and the Employees
                               current record is " & Forms!Employees.CurrentRecord

Copyright By AccessVision