I have a classic ASP form that I'm trying to update several records at one time. This connects to an Access Database which is housed on our web server. I had it all working but when I added my if then statement (because I have a radio button group that when its False I want it to report to field of the database) so I made an If then statement and now it says Data type mismatch in criteria expression. I've looked over the database and the form and it shouldn't be mismatched? Here is my if then statement
If strText = "False" Then Set strText2 = "True" Else strText2 = "False" End If
strText is my radio button group. If it returns a false value then I want it to populate the strText2 with false. These will populate checkboxes in Access. Is that the issue? Answer from Richard Rost:
Get rid of the word "set" which is used for objects.
If strText = "False" Then strText2 = "True" Else strText2 = "False" End If
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Active Server Pages Forum.