rs.movefirst doesn't seem to move to the first record

[mikewood1980]

Hi

I have a table that has primary key Id in text format. When I use the movefirst method and assign rs!keyID to a variable, the variable value is not the first record as it appears in the table...

Does anyone have any idea why this is?

Thanks in advance for your help

Mike Wood

 

[namliam]

A select statement without an Order by clause by default is random, try adding "Order by keyID" to your SQL.