.....[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)")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use In() Expression as Query criteria with guts from Function 1
Multiple Parameter Crosstab query filter by form 1
Query criteria problem !!!! Please help 1
Integers behaving like strings 4
Quering a drop down column from a table 2
Query with variable parameter 7
parameter from a form 1
Checking if data exists another table and, if yes, extracting a value 0

Back
Top