How do i create a condition to a field in the form in access 2007.

[Ghida]

for example, i want access 2007 ot give message whle entering data in the
form, under the visit date field when the value entered in this field is
smaller than the value in the call date field

 

[KARL DEWEY]

You can use the Validate and the Validation Text.

=[Forms]![YourFormName]![Call_Date]