Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Update (Refresh) control containing DLOOKUP 1

Status
Not open for further replies.

RDS2

Technical User
Jun 6, 2003
44
US
I have a DLOOKUP function as the bound source for a text box which returns a value based on a value entered in another control on a form. This works fine when the form loads or a new record is added. However if I change the source value for the DLOOKUP function the function does not update/refresh to reflect the change. Is there a way to have the form run the lookup when the source value changes without having to close and re-open the form??
 
You can put in the After Update of the source control code that will refresh the calculated control using the DLookUp:

Code:
Me![[i]calculated_control[/i]].refresh

Post back if you have any questions.

Bob Scriver
[blue]Want the best answers? See FAQ181-2886[/blue]


 
Thanks to Bob Scriver for the advice
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top