Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Location
    South Africa
    Posts
    178

    Red face Unanswered: query to read value from a form

    Hi All
    I've got a query that reads a value from a form.
    It works for the one query but not for the other one.
    In the criteria section of the query design view I have:
    [Forms]![MyForm]![MyValue]

    i get the error that the jet DB engine doesn't recognise it as a valid field name or expression.

    any ideas

    thanks in advance
    ActionAnt

  2. #2
    Join Date
    Mar 2004
    Location
    Nashville, TN
    Posts
    557

    Form and Query

    To Query off of a form textbox or form value, you have to have the form open and the value filled in when the query is run. I done this many times especially on my Find form that looks for a specific part or tool.

    Hope this helps,
    Jarvis
    Have you ever thought about thinking on purpose?

    Jarvis Stubblefield
    Patriot Designs
    Web/Database Development and Consulting
    The-Patriot.net by Patriot Designs

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •