Results 1 to 3 of 3
  1. #1
    DB2010MN26 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Sep 2010
    Posts
    37

    Unbound Text Box Input to Query Issue

    I'm having an issue getting an unbound text box to work with a query I've created. What I'm trying to do is take text entered in an unbound text box and put it as criteria in a query I've created. The form I have the textbox on is called [frmDS_BULD_DATA], My textbox is titled [Text7], my query is titled [qryAdHOC]. The field i'm trying to set criteria to in my query is ISS_ID.



    The criteria I entered in the query for the ISS_ID based on the expression builder is the following

    [Forms]![frmDS_BULK_DATA]![Text7].[Text]

    The issue is, when I try to run it from my form, rather than taking whats entered in my unbound text box, it asks me to Enter a Parameter Value for Forms!frmGS_BULK_DATA_VALIDATION!Text7.Text

    What am I missing?

    Thanks in advance.

  2. #2
    Robeen is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Mar 2011
    Location
    Tulsa, Oklahoma.
    Posts
    1,596
    You mention three Forms:
    1. [frmDS_BULD_DATA],
    2. frmGS_BULK_DATA_VALIDATION
    3. [frmDS_BULK_DATA]

    Which one are you working on here?

  3. #3
    DB2010MN26 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Sep 2010
    Posts
    37
    Only form I'm working on is [frmDS_BULK_DATA]

    The message it gives me is: Enter a Parameter Value for Forms!frmDS_BULK_DATA!Text7.Text


    Sorry for the confusion.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 06-28-2011, 06:40 PM
  2. Unbound form requery issue
    By kparker in forum Forms
    Replies: 2
    Last Post: 06-28-2011, 04:22 PM
  3. Replies: 15
    Last Post: 04-01-2011, 11:41 AM
  4. Input data In unbound text box
    By chu3w in forum Forms
    Replies: 1
    Last Post: 04-01-2010, 10:21 AM
  5. Unbound text box truncating text
    By gddrew in forum Forms
    Replies: 0
    Last Post: 03-02-2006, 11:26 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums