Re: form field data as criteria

From: Nikos Yannacopoulos (nyannacoREMOVETHISBIT_at_in.gr)
Date: 08/31/04 

Date: Tue, 31 Aug 2004 11:03:44 +0300

Rip,

It would be:

[Forms]![YourFormName]![YourControlName]

HTH,
Nikos

"RipperT" <anonymous@discussions.microsoft.com> wrote in message
news:322601c48f07$100df630$a601280a@phx.gbl...
> What is the syntax to type in the 'criteria' field of a
> query when you want to plug in the data from a form field
> when the query runs?
>
> Thanx millions?
>
> Rip

Relevant Pages

  • Re: Multi select box Query problem
    ... their own reports based on Multi Select List Boxes that are tied to a query. ... My problem I think is I'm using the queries Criteria box in the query design ... the criteria but an SQL syntax I use just won't work? ... Doug Steele, Microsoft Access MVP ...
    (microsoft.public.access.formscoding)
  • Re: Passing Criteria from a Form to underlyng Qry of Report
    ... box it passes it to the Query and everythign is fine. ... The syntax I used is ... The criteria field's datatype is Text? ...
    (microsoft.public.access.queries)
  • Re: Null value issue in Criteria
    ... Thanks Tom for the syntax. ... This above goes into the SQL View of the query in the place of your ... I currently have this in the Criteria in the query: ...
    (microsoft.public.access.queries)
  • Re: Parameter Queries
    ... When using a form for your parameters, the syntax for the criteria is ... boxes for my parameters but my query wont feed off my form. ... I am trying to create a query that asks you what criteria you want it to ... see everything that is in the under "Construction" and it will take me there ...
    (microsoft.public.access.queries)
  • Re: Multi select box Query problem
    ... However when I enter the syntax in to the query criteria... ... Doug Steele, Microsoft Access MVP ...
    (microsoft.public.access.formscoding)