dlookup function

[junmart]

please give me an example of this function. i cant get it to work. i have my "task description" field automatically updated based on whatever value was chosen in my "task ID". One task ID corresponds to a task description. do i use the dlookup function for this? and where do i put the code so my task description field will automaticall update? thanks a lot in advance!

 

[ColinEssex]

You will need to put the DLookUp OnExit of the field that has the ID in it and don't forget the Me.Refresh after it.

Col

 

[Rich]

Since TaskID relates directly to description use a combo box to display the description when selecting the TaskID