Results 1 to 2 of 2
  1. #1
    DDillesha is offline Novice
    Windows 2K Access 2007
    Join Date
    Oct 2009
    Posts
    1

    Pass a Parameter From a form to a Query

    How do i pass the data in a field that i DblClick to an Append Query? I'm having trouble understanding how the field is going to get passed to the Query.



    Or is there a better way to do this? ie.. can I DblClick a field and have it Append a Table? And how do i do it?

  2. #2
    CGM3 is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Atlanta, GA
    Posts
    49
    You can refer to fields (by name) on a form as parameters in a query. For instance, if you have a text field named txtPartNumber on form frmMain, and you want to execute a query that looks for all records (say, in an inventory) with the value shown in txtPartNumber as the value of the PartNumber field, you'd put this in the Criteria field for PartNumber in the query:

    Code:
    =[Forms]![frmMain]![txtPartNumber]

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

Similar Threads

  1. Report with Parameter Query/Form
    By maggioant in forum Reports
    Replies: 0
    Last Post: 10-09-2009, 09:48 AM
  2. I want to automatically pass a value to a query
    By Slategrey252 in forum Queries
    Replies: 1
    Last Post: 10-01-2009, 05:38 AM
  3. Parameter in Crosstab Query
    By RandyG in forum Queries
    Replies: 4
    Last Post: 09-30-2009, 06:40 AM
  4. Pull Parameter Value from Form
    By dymondjack in forum Queries
    Replies: 1
    Last Post: 02-14-2007, 07:15 PM
  5. Replies: 0
    Last Post: 03-19-2006, 11:52 PM

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