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?


its urgent...........

thanks

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.

HTH

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?

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.

data is changed by other user in access or by same user but from many different forms.

so what can i do?

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.