Checking for field value on form open

[Leila]

I am trying to find the syntax to check a fields value when
opening a form. The field is a text field. Can anyone help ?

 

[Sandra Daigle]

Depends on what you mean by 'Check a fields value' -

You can refer to it in a variety of different ways - for example the
following will display a msgbox when the value of the control named Text1
has the value "ABC":

if me!Text1 = "ABC" then
msgbox "the value is ABC"
endif