DLookup Refresh

[acnovice]

Hi,

Is there any way to refresh DLookup function in my subform ?

I have a main form(frmQchart) with a sub-form(sfrmSIsummary) with datasheet format and I'm using DLookup to bring up few fields (fob1,fob2,,,) from tblFOB.

Once I brought up the fields from sfrmSIsummary and change the data in fob1 & 2 later from tblFOB, they don't refresh the fields at all but main form refreshes my sub-form whenever I press the refresh button.

I want them refresh the DLookup fields automatically.
Following is one of my DLookup.

Me![fob1] = DLookup("fob1", "tblFOB", "[ShopPN]='" & Me![ShopPN] & "'")

Any help will be appreciated.

 

[GingerR]

Me![fob1].requery?

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[acnovice]

GingerR,

I tried yours but it doesn't change anything at all.

Thank you.

 

[assets]

Me![subform].Requery

Never give up never give in.

There are no short cuts to anything worth doing

 

[WildHare]

I don't believe DLookup refreshes on a form requery. It is a function that needs to be re-executed to perform the lookup and retrieve operation.

DLookup and other "Domain functions" are very useful, but "expensive" to run.

In the past, I've done this kind of operation by placing the Dlookup code in a procedure, and calling the procedure on a form_CURRENT event or something similar.


Don't be sexist - Broads hate that.

 

[acnovice]

WildHare,

You're right. I need a DLookup function to be re-executed not a form refreshing. I can put a code in On_Current event but one thing that I'm considering is "causing performance issues". If I can control the event refreshing interval, it would be nice.

Thank you.

 

[hext2003]

OK Stupid sub question here??

What is the refresh key?

 

[hext2003]

I mean Refresh Button???

 

[hext2003]

Sorry Got it, Shift + F9

Thanks!