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

    Red face Unanswered: query to read value from a form

    I'm trying to run a query based on a value that I entered on a form.
    the form is still open.

    I keep getting the error that the Microsoft Jet Database engine doesn't recognise [Forms]![ASN]![text1] as a valid field name or expression.

    what could the problem be?

  2. #2
    Join Date
    Jan 2004
    Posts
    75
    1) Go to the form in question. Double check the properties of the text box to make sure you're calling it by the right name.

    2) What type of query is it?

    3) Where are you putting the reference?

    Perhaps posting the actual query would be more helpful...

  3. #3
    Join Date
    Jan 2004
    Location
    South Africa
    Posts
    178
    I managed to sort out the problem.
    I think it wouldn't let me read from a form because my query was also querying from a crosstab query.
    so what I did was change my query to a make-table query and then let the make-table query lookup a value on my form. that solved the problem.

Posting Permissions

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