My syntax is Phooey.. Take a look

[redbull]

Alright, I am trying to see if the value of 2 columns on a record exist on a webpage... It is giving me syntax errors even though I have used this method in the past.


This line is not working

If InStr(oIe.Document.all.tags("div").Item(29).innertext, r![f13] & " " & r![f14] > 0 Then

This code below works fine, it tells me if the value of a textbox on a form is on the webpage...

If InStr(oIe.Document.all.tags("div").Item(29).innertext, Forms("frmmainnew").txtaddUser1) > 0 Then

So, the top line of code is not working, the bottom one is... Can anyone steer me in the right direction here? Any advice is appreciated.

[pbaldy]

You probably want to close off the quotes of the InStr() function.

[redbull]

HAHA, that was it. Thank you... I only had one cup of coffee today and my grey matter has the consistency of pudding. Rep Added.

[pbaldy]

Happy to help!