Hello.
I have data on SQL server. Say for example tblPeople with 2 fields:
Name = obvious
Invited = flag whether they were invited or not
Let's say there's two rows, for John and Sally.
In Access, I've saved a pass-through query to quickly grab tblPeople= qryTest. On the main form, I have a subform(datasheet) that refers to qryTest, and shows me John and Sally. This recordset is not updateable, I presume b/c it's relying on a pass-through query.
When I press a button on the main form, I send an pass-through update query to change the Invited flag. On the server, I can see the flag has been updated. I want to then update just the ONE row I'm (say John's row) in the datasheet to reflect the update, without updating the whole datasheet. So I've been trying the requery method, with no luck. It's as if I have to run the whole query again, but I'm trying to avoid that. Thoughts? Thanks!
I have data on SQL server. Say for example tblPeople with 2 fields:
Name = obvious
Invited = flag whether they were invited or not
Let's say there's two rows, for John and Sally.
In Access, I've saved a pass-through query to quickly grab tblPeople= qryTest. On the main form, I have a subform(datasheet) that refers to qryTest, and shows me John and Sally. This recordset is not updateable, I presume b/c it's relying on a pass-through query.
When I press a button on the main form, I send an pass-through update query to change the Invited flag. On the server, I can see the flag has been updated. I want to then update just the ONE row I'm (say John's row) in the datasheet to reflect the update, without updating the whole datasheet. So I've been trying the requery method, with no luck. It's as if I have to run the whole query again, but I'm trying to avoid that. Thoughts? Thanks!