I am Microsoft Access (Office 365). Note : I am using continuous forms.
I have a field that only holds two values. They are Null or "Y". If I change the value by hand, I do not get a screen flicker. If I do it using VBA, (activated by the click event on that field), the code below flips the value with the bonus of a screen flicker. I have asked a similar question in the past and received answers that minimized the flicker, but I really hope that you can help me eliminate the screen flicker when changing a value of a field in an existing record using VBA.
Private Sub FlipTag()
Dim TheTable As String: TheTable = "[tblCreate StockItems]"
Dim TheTag As String: TheTag = "[Tag_CreateStockItem]"
Dim TheStockNum As String: TheStockNum = "[Stocknum]"
Dim strNewValue As String: strNewValue = IIf(Nz([Tag_CreateStockItem], "") = "Y", "Null", "'Y'")
Dim TheStr As String
TheStr = "UPDATE " & TheTable & " Set " & TheTag & " = " & strNewValue & " where " & TheStockNum & " = " & [StockNum]