I've got a view that's accessing an Access table. Whenever I'm testing things out in my command window I can use tablerevert() to get the underlying table not to take the changes. They just disappear. But when I'm in my form and I put that tablerevert() in the click of a button it doesn't do me any good. I mean, there's no reaction at all. It's as if it's not there.

I was wondering if it's possible I've got some kind of doublebuffering going on here. I mean, perhaps the view is like a buffer for the remote table and then when I get into the form there's some other buffer for the view. So when I tell it tablerevert() it's reverting the view but not the underlying remote table. Is that possible, or am I overthinking it?

If anyone has a hint for me about how to get this revert to "take" I'd appreciate it.