How to add click value in the table?

[accessman2]

Hi:

I have a table, there is a field Yes/No (Click button), the default is nothing.

After running the function, the Yes/No (clcik button) has added click.

in VB code,

How can I write? Is it just type Yes, then the result will click itself in the table.


Please let me know, thanks.

 

[Pat Hartman]

If your form is bound, then clicking on the form will result in the value being stored in the table. To set the value in code:

Me.SomeField = True
or
Me.SomeField = False

For checked, you can use -1, True, Yes, On
For unchecked, you can use 0, False, No, Off