May 7 2005, 09:15 AM
i have a problem...
i have some forms with bound data. when i update the current recordset from a query then new data does not show up until i make a manual refresh.
the table is on an ms sqlserver 2000. i use a mdb with linked tables.
before i changed to sqlserver then new data showed up automaticaly after a second or so. ho can i achive this without changing to an adp (i tried an it doesn't help :-( ).
i implemented an refresh-button which works fine, but its not good that all the guys have to click there to view changes.
is there a way to trap changes made by someone else on the current data?
May 7 2005, 09:19 AM
Please do NOT cross post. Use ONE appropriate forum.
You need to REQUERY the form, not Refresh. A Requery will pull any new changes made to the Recordsource.
May 7 2005, 09:23 AM
but how do i know WHEN to requery?
how does the form know its time to make a requery?
when i want to change data the form tells me that data has changed.
how to detect it without having to edit data?
May 7 2005, 09:29 AM
That depends on your work flow. I gather that data may be changed outside the Access application or by other users. So it depends on how your work flows.
May 7 2005, 09:39 AM
data is changed by other user in access or by same user but from many different forms.
so what can i do?
May 7 2005, 10:11 AM
When another form is saved, you can Requery the open form. You can put in a Requery in the ON current event so the form is requeried whenever you change records.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here