I am trying to write an if statement to test the value of a check box (Billed). Here is the code:
If Me.CDG_Billed_ Then 'if CDG_Billed? (Please note that the column name is CDG Billed?)
...
But this does not seem to catch the value of the check box. I've also tried If Me.Billes = "Yes", "Y" and 'y' (seperately of course). I've also tried changing the name of the column to not have the ?. But this did not work as well.
If Me.CDG_Billed_ Then 'if CDG_Billed? (Please note that the column name is CDG Billed?)
...
But this does not seem to catch the value of the check box. I've also tried If Me.Billes = "Yes", "Y" and 'y' (seperately of course). I've also tried changing the name of the column to not have the ?. But this did not work as well.