I am using a continuous form in Access 2010.
I have a database field [tag] which only accepts "Y" or "N". It's the only field that I have not locked. I can type in "Y" or "N" and that is fine, but I would like to do this programically via double click. Here is the code.
Private Sub Tag_DblClick(Cancel As Integer)
If Nz(Me.[Tag]) = "Y" Then
[Tag] = ""
[Tag] = "N"