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

    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:

    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

  2. #2
    Join Date
    Mar 2004
    Nashville, TN

    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,
    Have you ever thought about thinking on purpose?

    Jarvis Stubblefield
    Patriot Designs
    Web/Database Development and Consulting 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