Originally Posted by
pbaldy
Me always refers to the object the code is in, ie the form. ........
One reason I was asking is the the first line of the following works for me, but the second, as an alternative, does not:
Code:
strWhere = " where tblshoots.Shootsid = forms!frmMain.cboShootName"
strWhere = " where tblshoots.Shootsid = Me.cboShootName"
This is in the construction of a SQL fragment in the afterupdate code of a combobox contained in frmMain. So I'm still not clear whether one can categorically use "me" for the form object in all contexts.
Thanks for the response and the link. -Ron