Referencing a filtered form's current record fields in Access 2007
Posted on 2013-01-22
I have a form with a MySQL ODBC record source that is filtered to show only one record. Not all the fields from the record are bound to the form.
Is there a way to reference fields from the filtered record in VBA that are not bound?
For example, if the table has ID, field1, field2. On the form I have myField1 that is bound to field1. The filter on the form is based on ID=2. In VBA I would like to check the value of field2 without having to add an invisible control or without having to do a temp recordset.
I would like to use something like MyTable.field2 or currentrecord!field2 . Neither of these seem to work.