Query Critieria using Combo Box Column

[MintChipMadness]

From what I understand, I can't use a different column other than the first to filter query criteria. To get around this I made the first column the search criteria I need and then hide it by putting the column width to zero.



I did see another solution somewhere but I can't find it again. It is using VBA to add the column amount to a variable and then filtering the search criteria by that variable. Unfortunately I don't know how to do this in VBA so I am asking here if anyone knows the answer.

[pbaldy]

Haven't seen it, but likely something like this:

Public Function ComboForQuery() AS AppropriateDataType
  ComboForQuery = Forms!FormName.ComboName.Column(x)
End Function