recordset.seek with compound field lookup issue

[vabki]

My base table has an index based upon 2 fields, the first of which is a string type and the second a date type. Even though the basis for the record's fields and the seek arguments uses the same code construct, the seek fails. Is there some special connotation that I need to use to format the date portion of the seek argument's values?

my seek command looks like rs.seek "=", strArg1 & stArg2 followed by if rs.nomatch then...

 

[vabki]

found it

for those of you who are still thinking about this, the answer is that the key fields should not be concatenated but separated by commas...

thanks anyway!

 

[Pat Hartman]

I wouldn't use seek at all. I would add criteria to my query so that only the records I want are returned in the recordset.