DDE: not dynamic with Access97 ???

[snorkyller]

I try to make a link between Access97 and
an another application.

I put the DDE function in the ControlSource property
of a Textbox and I got the value requested.
Here is the DDE function that I use:

=DDE("Excel", "Sheet1", "R1C1")

In an another message, I asked help because it
won't work. But I'm ok now with that.

Now, the problem is that I got the
value of the cell only one time. I mean that
if I modify the cell "R1C1", it doesn't modify
automaticaly the value of the Access97 TextBox.
It supposed to be dynamic, so I don't understand!!!

It seem that DDE is dynamic with Excel,
Visual Basic, Word, etc but not with Access!!!

If I do the same thing with Excel
by putting the following in a cell:

='Excel'|'Sheet1'!'R1C1'

The value of this cell will change dynamicaly
if I change the value of "R1C1"

Also, if I try with Visual Basic by setting
the properties of a TextBox like the following,
it will be also dynamic:

LinkTopic= Excel|Sheet1
LinkItem= R1C1
LinkMode= automatic

My question is: Do you know if Access97 really
don't support dynamic DDE (it would be ridiculous
because DDE mean "DYNAMIC Data Exchange")?

If no, what should I do for making the TextBox
value change automaticaly in the same time of the
cell?

I know that in /Tools/Option/Advanced, you can
set the DDE update interval but it change
anything when I set it to 1 seconde...

Thank you for helping me if you can!