Need to understand code

[accessnewb]

This may be a silly question but, I found this code online and used it on my form and it works!. This is the code (used as a macro):



SetTempVar
Name ActiveControlValue
Expression = [Screen].[ActiveControl]


SearchForRecord
Object Type
Object Name
Record First
where condition =="[lngID]=" & [TempVars]![ActiveControlValue]

So basically what happens is I have this combo box and there is a textbox below it. If I click on some other value in the combo box, then the textbox value automatically changes.

Now I am curious as to how the code works. Could someone explain?

Thanks!

[Dalagrath]

I am aware that the ActiveControl part is focusing on the Active box/field you are in.

"Screen.ActiveControl Property (Access)." MSDN Explore Desktop, Web, Cloud, and Phone Software Development. Web. 03 Aug. 2011. <http://msdn.microsoft.com/en-us/library/ff844755.aspx>.

[accessnewb]

umm..and what does this line do?

where condition =="[lngID]=" & [TempVars]![ActiveControlValue]