I'm using code from 'Beginning Access 2002 VBA' (page 226) This works (of course!) on a test database and on the -be database but not on the front end database where 1 is returned. I have changed the db.OpenRecordset to be dbOpenDynaset (as suggested on page 231) but to no avail. Am I correct to think the 1 is a pointer record. How can I get this to work?

I don't have the book in front of me. Can you explain what you are trying to do?


mmcdonal