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

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Steve S (SteveS_at_discussions.microsoft.com)
Date: 02/08/05 

Date: Mon, 7 Feb 2005 19:51:01 -0800

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

Relevant Pages

  • RE: Filtering a subform using many combo boxes
    ... "Steve Sanford" wrote: ... SELECT AssignedPriority, AssignedPriorityDetail FROM tblAssignedPriority ... I followed you instructions to the letter and every one of the criteria ... open the query "qryProjects" in design view. ...
    (microsoft.public.access.forms)
  • Programatically Changing Query Criteria
    ... Save your query in SQL. ... the following to determine your criteria. ... Dim strSQL As String ... MsgBox "There was a problem building the SQL String" ...
    (microsoft.public.access.macros)
  • Re: Complex query criteria - desperate appeal
    ... I made an ASP website using an Access DB ... criteria listboxes have the ALL choice, and the value passed to the query is ... I then build a string of the selected ID's and use ...
    (microsoft.public.access.queries)
  • Re: Passing multiple strings from a text box to a select query
    ... Search Criteria database page on your website have given me lots of new ... Will a filtered form allow a subform that displays records from a query ... The article explains how to create the string to use as the WhereCondition ... This allows me to enter "seat" in the text box and return ...
    (microsoft.public.access.forms)
  • Re: filtering by month
    ... Change the calculated query column to: ... Steve S ... FROM Enrollment ... you suggestion along with the criteria. ...
    (microsoft.public.access.queries)