.....[ComboLevelID].[column](2) error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I try to use "=[Forms]![frm-Add Entries]![ComboLevelID].[column](2)" as
a criteria in a query I get an error. This string works everywhere else I
try to use it. Steve
 
There are a couple options:
1) Set the bound column of the combo box to the value you need in the
criteria and use:
=[Forms]![frm-Add Entries]![ComboLevelID]
2) Add a text box on the form with a control source of:
=[ComboLevelID].[column](2)
Then use this new text box in the criteria
3) Set the criteria to:
=Eval("[Forms]![frm-Add Entries]![ComboLevelID].[column](2)")
 
Back
Top