Make Toggle Button enter data on press and delete data on unpress

[Historypaul]

I'm trying to work with a toggle button to enter a date into a table when pressed and delete that date if unpressed. I wish I could tie a macro into the state of the toggle button, but it seems I just have to use the On Click event with an if/then macro hoping that the button condition and cell condition don't get out of sync. However, trying to write a macro to handle this doesn't seem to be working. Below is what I've written. I don't get an error. It just doesn't seem to do anything.

Private Sub Toggle96_Click()
If Me.Frame_Stripped = Null Then
Me.Frame_Stripped = Date
Else: Me.Frame_Stripped = Null
End If
End Sub

[June7]

Can't test for null with = null. Review http://allenbrowne.com/casu-12.html

If IsNull(Me.Frame_Stripped) Then

[Missinglinq]

...hoping that the button condition and cell condition don't get out of sync...

As for being sure that you're doing this to the Record you intended to do it do, instead of using a Toggle, I'd use the DoubleClick event of the Control for the Date Field. That way you'll know which Record you're working with...no guessing!

Linq ;0)>

[Historypaul]

Thanks, June7. I knew it had to be something simple I missed. I read the reference you gave me. Your advice got the first part of the macro to work, but I think I was mistaken on how the toggle button reacts period. I had it linked to a query and maybe because it wasn't updating the table, it wouldn't stay down even when there was data in the table. Now that I linked it directly to a table, it stays down - doesn't come back up unless you delete the value from the table. I ended up using the double click event to clear the data from the table, which resets the toggle button.

- Missinglinq - That is a great idea, but I don't actually want the user to see that this action is entering a date. I'm using a multiple items form and so far, I haven't seen anything that would make me worry about the control not associating with the right record. My "getting out of sync" concern was due to the toggle button going up or down with each press regardless of whether there was data in the cell or not when I was testing it out linked to a query...