AlaskanDad
Programmer
I'm trying to update my recordset using a for next loop but want to skip the first dropdown box because it is only being used for navigation.
Here is a synopsis of my current code:
If request.form ("SaveButton"
= "Save Changes" Then
For x = 1 to request.form.count
If request.form (x) <> "Save Changes" Then
myRS.Fields(x) = request.form(x)
End If
Next
End If
This cycles through all of the values sent from the form and skips over the Submit button because the value is "Save Changes".
The first form item is a dropdown box
Name: ContactSelect
Value: Some value between 1 and 1000
How do I get the If Then statement to also skip the ContactSelect box?
Thanks in advance,
Rob
Here is a synopsis of my current code:
If request.form ("SaveButton"
For x = 1 to request.form.count
If request.form (x) <> "Save Changes" Then
myRS.Fields(x) = request.form(x)
End If
Next
End If
This cycles through all of the values sent from the form and skips over the Submit button because the value is "Save Changes".
The first form item is a dropdown box
Name: ContactSelect
Value: Some value between 1 and 1000
How do I get the If Then statement to also skip the ContactSelect box?
Thanks in advance,
Rob