Results 1 to 2 of 2
  1. #1
    Candy_Tech is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Jan 2017
    Posts
    6

    Creating a Search Form- Report

    Hello,
    I am trying to create a search form that searches data in a report design.
    I created a report design that contains nutritional labels. I want to search by "item number". the item number data is on report design.
    I have already created a search form, but it only searches a query.


    How can I create a search form / command button to search my report for the item number?
    Eventually want I want to do is have the search form find the label with the correct item number, then print that specific label.
    Any help/ advice?

  2. #2
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,511
    When you say on report design, do you mean it is hardcoded in a label or something on areport or is it in a field from a table on the Report? Seems you would create a combo box of the item numbers and then base the report criteria on this combo box value from the form.

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

Similar Threads

  1. Replies: 1
    Last Post: 11-30-2016, 03:41 AM
  2. Replies: 8
    Last Post: 09-02-2015, 03:00 PM
  3. Creating a report based on partial field search
    By pirseinkim in forum Reports
    Replies: 1
    Last Post: 03-22-2013, 11:08 AM
  4. Replies: 3
    Last Post: 01-14-2010, 08:32 AM
  5. Replies: 5
    Last Post: 07-26-2009, 12:13 PM

Tags for this Thread

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