I'm trying to get a value from a textbox(email address) and assign to a variable..
Then before inserting variable into sql statement replace the ' with a ""
But this statement will not even match on the variable ?
eStr = Me.CALLER_EMAIL.Text
If eStr = "BILL.O'CONNOR@RRR.COM" Then
eStr = "BILL.OCONNOR@RRR.COM"
IF BILL.O'CONNOR@RRR.COM is the variable eStr it still will not hit on the If....Then statement ?