Full Version: Added a new record but when I try to move to it......
UtterAccess Forums > Microsoft® Access > Access Forms
JeremyJones
I added a new record to a table, and I need to reflect on my form, so I do a refresh and requery. When I try to move to the new record, it states "You can't go to the specified record", but then it does any way. What could possibly be going on.
JVanKirk
Well, the record should be getting added via the form...is your form bound to the table? IF so, you shouldn't need to to a refresh and a requery...everything should be there right off. Usually a refresh will refresh the form without moving to the start of the records, and the requery will...
nyway, short of that, you could try to do a compact and repari to see if maybe sometihng got corrupted...make sure you make a backup of your db.
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.