Results 1 to 2 of 2
  1. #1
    Meccer is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jan 2011
    Posts
    17

    Search Criteria

    Hello,

    I've got a textbox (Search) and a dropdown (Category). I want to enter text in the textbox and select from which category to search in, and this will open a report.

    When I enter text and choose a category and click on the button, a pop up shows up saying "Enter Paramater Value". How can I get it to go straight to the report?



    I've used embedded macro:
    OpenReport (Command)
    Report Name = Contacts
    Where Criteria = ="[Search]=" & [Category]

  2. #2
    kennejd is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Mar 2011
    Posts
    188
    The criteria has to be an actual field in your report's recordsource. I don't use the embedded macros, but I would think you will need to reference the form.

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

Similar Threads

  1. Search By Criteria - Flexible Criteria Fields
    By lilanngel in forum Access
    Replies: 0
    Last Post: 03-16-2011, 06:25 PM
  2. Search with multiple criteria
    By injanib in forum Forms
    Replies: 1
    Last Post: 01-16-2011, 11:51 PM
  3. Search Button with Multiple Criteria
    By injanib in forum Forms
    Replies: 2
    Last Post: 01-12-2011, 02:21 AM
  4. search criteria in a form fails!
    By maxbre in forum Programming
    Replies: 2
    Last Post: 12-01-2010, 06:21 AM
  5. Replies: 2
    Last Post: 08-31-2010, 08:57 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