Group: alt.fan.countries.uganda · Group Profile · Search for but searching in alt.fan.countries.uganda
Author: Otis Willie PIO The American War Library
Date: Jun 7, 2010 15:09
Try this -- Your table having Field1, Field2, Field3 and Field4. Combo having two fields -- 1 Field1 2 Field2 3 Field3 4 Field4 Search_Field: IIF([Forms]![YourForm][Cbo1] = 1, Field1, IIF([Forms]![YourForm][Cbo1] = 2, Field2, IIF([Forms]![YourForm][Cbo1] = 3, Field3, Field4))) Criteria: [Forms]![YourForm][Text1] -- Build a little, test a little. "vander via AccessMonster
|