Is it possible to use a variable to pass a fieldname in the Where condition of a BrowseTo action in an Access 2010/Sharepoint 2010 hybrid web form? I have a form where
Where condition= [fieldname] Like "*text value*"
filters the records correctly, but if I set a temp variable to "[fieldname]" and use
Where condition=[TempVars]![fieldname] Like "*text value*"
no records are returned. Is there a syntax that will allow me to use a variable in place of the actual fieldname? I'm filtering the recordset based on a combo box selection plus a text field entry. If I can use a variable instead of the native fieldname it will save me a whole bunch of If statements in the macro.