Results 1 to 2 of 2
  1. #1
    Juan4412 is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    Dec 2010
    Posts
    200

    Parameter Passing

    How can I pass parameters from a combo box on a form into a begin date and an end date field in a query? I may be inputting it improperly, but I tried
    [forms]![formName][comboboxname]

  2. #2
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,493
    Your attempt looks ok. What result are you getting? What result did you expect? Perhaps you should post your SQL statement for your query or a copy of your database for us to look at. If you post your db, do a compact and repair and only post some sample dummy data.

    BTW: I just noticed that you are missing a period "." between the form name and the control name. Is this just a typo here or is it missing from your criteria also.

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

Similar Threads

  1. Passing List of Parameter
    By vignes10 in forum Access
    Replies: 3
    Last Post: 09-15-2011, 07:35 AM
  2. Passing a Picture frame as a parameter
    By SacredFootballLB in forum Forms
    Replies: 1
    Last Post: 09-30-2010, 11:40 AM
  3. Replies: 10
    Last Post: 09-27-2010, 08:06 PM
  4. Macro passing a parameter
    By SlowPoke in forum Access
    Replies: 1
    Last Post: 09-26-2010, 09:57 PM
  5. bypassing passing parameter when null
    By cowboy in forum Queries
    Replies: 11
    Last Post: 04-14-2010, 09:59 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