findfirst command
im am trying to find some records in a database using
Data1.Recordset.FindFirst "location=" & "'" & strseek & "'"
the problem i am having is that the "location" field always changes in the project, though diff names go into the same field , is there a way to code this so that this field can be used with a var instead of the actual field name in the database? example:
data1.recordset.findfirst "myvar" & "'" & strseek & "'" ???
this doesnt work but i am just trying to give an example of what i think it SHOULD look like.. thanks in advance to all who reply
Reply With Quote
