How to refresh a textbox linked to a query

[Danglez]

I have a textbox linked to a query using dlookup
=DLookUp(" [Current Position]![Current Position] ","Current Position") which reflects a sum of money.

I am using a continuous datasheet and when I enter in a new amount, the textbox does not refresh although the query does. How can I make this textbox refresh without me having to close the form or switching to design mode and back?

Thanks

 

[PHV]

And what about [name of textbox].Requery ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Danglez]

I have a textbox on my form named 'amount'.

I would like my 'current position' textbox to refresh or requery whenever the amount box in any record is specifically updated.

Currently it only refreshes when a new record is entered.

I would like it to refresh for example when I tab away from the amount box or change the amount in a record.

Thank you for your help

 

[PHV]

Do the Requery in the AfterUpdate procedure of the amount control.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[ckhunley]

Hopefully this thread is still active and someone can help. I want to do the same thing that Danglez is talking about, but in Excel. It is the same situation, but there is no requery command. Any ideas?
Thanks,
Chris

 

[RoyVidar]

Then there might be better advice in a forum where Excel is discussed, for instance forum707, this is Access Forms forum.

I think in Excel the command is:

[tt]application.calculate[/tt]

To perform this from Access, then use the object variable used for the Excel application:

[tt]objExcel.calculate[/tt]

Roy-Vidar