Help needed with Access Recordset

[dok112]

Hey everyone,

I can't seem to figure out what's not working here. I've put everything in, and it runs but for some reason, it's not pulling the correct number. When I run the code, it returns the last entry for the Survey_ID field. However, if I add a new record to the table and re-run it. It still returns the same one as last time. Anyone have any ideas on how to get it to pull the correct ID number?

It's almost as if each time it's run, it's not clearing the recordset or requerying the db for an updated recordset.

Please Login or Register  to view this content.

[dok112]

Anyone have any thoughts on this? I could really use the help.

TIA