I'm trying to figure out if there is a way to refresh a single record in a datasheet subform (based on a query) using a VB statement.
Currently I have a FormA (a series of test/combo filters) which launches queries/reports based on input (never closes). FormA also launches seperate FormB, which contains SubFormB (a data sheet view form which is based on the results of QueryA based on filters in FormA). When a user click on a record in SubFormB it pops up PopFormB, which contains values which can be edited (defaulted to corresponding SubFormB values). Edits can then be made and upon close those values appended to TableB in a remote database along with a timestamp.
QueryA is based on records from TableA outerjoined to QueryB (which picks the most recently updated record for a given key, based on timestamp.
Currently the process of refreshing QueryA (and thus SubFormB) takes approxametaly 20-60 seconds (could contain tens of thousands of records), which is why a complete refresh of SubFormB won't work on close of PopFormB.
So I guess the question is whether there is anyway of refreshing the single updated record (presumably based on a value passed to PopFormB from SubFormB and used by PopFormB on close).
Thanks, and I hope that the question is understandable (I feel like answering the Trains will meet in cleveland.)
-Eric
Currently I have a FormA (a series of test/combo filters) which launches queries/reports based on input (never closes). FormA also launches seperate FormB, which contains SubFormB (a data sheet view form which is based on the results of QueryA based on filters in FormA). When a user click on a record in SubFormB it pops up PopFormB, which contains values which can be edited (defaulted to corresponding SubFormB values). Edits can then be made and upon close those values appended to TableB in a remote database along with a timestamp.
QueryA is based on records from TableA outerjoined to QueryB (which picks the most recently updated record for a given key, based on timestamp.
Currently the process of refreshing QueryA (and thus SubFormB) takes approxametaly 20-60 seconds (could contain tens of thousands of records), which is why a complete refresh of SubFormB won't work on close of PopFormB.
So I guess the question is whether there is anyway of refreshing the single updated record (presumably based on a value passed to PopFormB from SubFormB and used by PopFormB on close).
Thanks, and I hope that the question is understandable (I feel like answering the Trains will meet in cleveland.)
-Eric
