Link to home
Start Free TrialLog in
Avatar of GNOVAK
GNOVAKFlag for United States of America

asked on

Referencing a filtered form's current record fields in Access 2007

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.
ASKER CERTIFIED SOLUTION
Avatar of pteranodon72
pteranodon72
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of GNOVAK

ASKER

Thanks!  Great!