Search results

Thanks Paul, worked a charm: ="[Company] = " & "'" & [Forms]![Account and Model Costs Query]![CompanyCB] & "' And [Model Code] = " & "'" & [Forms]![Account and Model Costs Query]![ModelCode] & "'" :D

Hi All, Struggling a bit with a 'Where' condition on a 'SearchForRecord' macro that I'm trying to build in Access 2010. I have a column in a query called 'Company' and another called 'Model Code'. I have two corresponding combo boxes on a form called 'CompanyCB' and 'ModelCode'. I am trying...