Hello all
Just a quick question:
Why does this work perfectly:
RunTimePoints.Value = DLookup("PTPoints", "Point Table", "PTRun = [RunTime]")
yet, this doesn't:
rst.Fields("RunTimePoints").Value = DLookup("PTPoints", "Point Table", "PTRun = " & rst.Fields("RunTime").Value)
I'm getting a runtime error #3075 on this line. I have a funny feeling it's having to do with single/double quotes.
[RunTime] is a text field.
Any thoughts would be appreciated.
Just a quick question:
Why does this work perfectly:
RunTimePoints.Value = DLookup("PTPoints", "Point Table", "PTRun = [RunTime]")
yet, this doesn't:
rst.Fields("RunTimePoints").Value = DLookup("PTPoints", "Point Table", "PTRun = " & rst.Fields("RunTime").Value)
I'm getting a runtime error #3075 on this line. I have a funny feeling it's having to do with single/double quotes.
[RunTime] is a text field.
Any thoughts would be appreciated.