Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2005
    Posts
    196

    Unanswered: Passing value from form into query

    In the design query builder, I'm trying to use a value in a text box as the value in a query (the actual value rather than the query criteria).

    Code:
    WDays: [Forms]![frmCIRatio]![txtnoOfDays].[value]
    However, when I run the query, it asks me for the value of Wdays, even though the form is open. Is there a way to do this or will I have to write the value to a table and then pass it into the query that way??

  2. #2
    Join Date
    Apr 2005
    Location
    Zagreb - Croatia
    Posts
    372
    In query criteria put:
    [Forms]![frmCIRatio]![txtNoOfDays]

  3. #3
    Join Date
    Aug 2005
    Posts
    196
    Yes it worked - worked it out just before I read your answer! - many thanks for your help.

Posting Permissions

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