VBA to grab current subform field value

[tylerg11]

Hi-



I have a button on my subform that needs to grab the current value that ties my subform to the main form. For example, if the EmployeeID field ties the main form with the subform, but this field is not displayed on the subform, what do I have to code to get the EmployeID for the current record?

[RuralGuy]

Me![EmployeID] should do it.

[tylerg11]

Thanks. That worked. I wasn't aware that you could retrieve a value from a form even if it isn't on the form itself...it just has to be in the record source for the form. Correct?

[RuralGuy]

Correct. It is why most developers use a different name for a bound control than the name of the field to which it is bound. Access can get confused when they are the same and you want "the other" one.

[tylerg11]

Thanks much!