how to refresh data after odbc update

[Toot]

Hi,

I know my question is going to be a little off topic. I need to refresh a MSaccess database subform after new data was transferred with the TCP/IP data logger software with the ODBC plugin. Right now i am using a timer that refreshes the whole form. Not an ideal situation. What i need is a refresh trigger (VBA or thru ODBC or something) that is triggered as soon an new data enters the data base. Maybe i need to find other way of transferring the data?  DDE? The nice thing about ODBC is that i can even close the application but still recieve data in the database. Now only if i could find a way to refresh when new data arrives.

who can help me with this one? Thanks in adance.

Otto

[Arthur Grasin]

You can activate and use the DDE Server. You should link your form with one of DDE items (for example date/time stamp). You'll receive a notification when this item will be updated and refresh your table.

[Toot]

Thanks,

I've looked in the tutorial but could not find a good example on how to do this. How do i refer to a DDE link in MSaccess?

Otto