Check Yes/No Data Type

[jamesormi]

Hi,

I have a table which contains a number of customer records.

When a customer is selected I would like to check the customers table to see if a Yes/No Data Type field has been set so that different operations can be performed when this option has been selected.

My question is... How do I programmatically check the Yes/No DataType to see if it has been set.

Thanks in advance.

 

[vbaInet]

The Yes/No data type returns -1 and 0 respectively. Use the DLookup() function to find specific data.