Yes=1 and No=0

[iraidotel@yahoo.com]

Hi All,
I have a table datatype number
The table I made to the form.
what if in the form number made in the text, and the data in the table fixed number,
I send files attached exels his

teremakasih, Ira Borneo

 

[CJ_London]

in the controlsource for each 'yes' control put

=iif([greadbox]=1,"YES","NO")

or

=iif([bench]=1,"YES","NO")

 

[gemma-the-husky]

however note that in "true" vba terms, YES is actually -1, not plus 1

YES is -1, and everything else is NO