Hi,

I'm running a query in VBA and it doesn't work when I try to clear the
value in Flag_Reason. When I use this:

sqlstr = "UPDATE Monthly_Transactions SET FLAG = FALSE, Flag_Reason =
'' WHERE (MCC_Code = 7299 AND Record_Initiated = FALSE)"
CurrentDb().Execute sqlstr

it doesn't work. But when I use this:

sqlstr = "UPDATE Monthly_Transactions SET FLAG = FALSE, Flag_Reason =
'a' WHERE (MCC_Code = 7299 AND Record_Initiated = FALSE)"
CurrentDb().Execute sqlstr

It works. I'm baffled.

John