I have an Access 2007 form, that contains a sub-form, and I would like to hide a field that is part of the sub-form. I have the field defined on the sub-form because it is retrieved as part of a query that is used to populate the sub-form. I need the field there to serve as an index to another table, if someone clicks / double clicks on a line on the sub-form. I have set the field as Visible --> NO, but that doesn't seem to do it.
Any help would be appreciated.