It’s always a nightmare when you’re trying to reference a control from one Form to another or one Report or another. You think you’ve typed it correctly but it’s still not returning the value. Here are two ways to get that accomplished…
From The Access Web… Refer to Form and Subform properties and controls
OR
[…]