Re: Microsoft Access and Oracle 8.17

Really, it's an Access question, but check out the Refresh method.

You could refresh the form in the After_Update event for the Volume control on the form. (Something like Me.Refresh)

Since this is not a change to the underlying recordset, I don't think you need to use the Requery method.

Hope this helps,

Anne

Martin Forsberg wrote:

> Hi,
>
> I am using Access as my client and Oracle 8.17 as database. Here is my
> problem:
>
> Table_1 (Oracle table)
> -------------------
> Id number
> Volume number
>
> In Acces I have a form displying Id, Volume and one calculated field:
> =(Volume)/1000.
>
> The problem is when I update the volume field the calculated field will not
> update. I must close and open the form again, then the calculated field is
> up to date. Is there a refresh function in Access or how should I solve
> this?
>
> Regards,
>
> Martin
Received on Fri Mar 22 2002 - 20:38:08 CET