Results 1 to 5 of 5

Access Search Form that opens a Report

Threaded View

  1. #1
    Registered User
    Join Date
    06-26-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    22

    Access Search Form that opens a Report

    Hello All

    I have a table with 20 fields in it and I am trying to create a form so users can easily search for records. I would like something that has two combo boxes, a date range and one text box. The combo boxes would be tied to a particular field (Function, Rec Item), while the text box needs to search through all of the other fields. Once the search is done I would like it to open a report only showing records that match the the criteria set.

    I have seen things similar to this but the results always appear in a sub form and I cant do anything with it after that, at least to my knowledge.

    Thanks in Advance
    I am using Access 2007.
    Last edited by Zachraeth; 07-31-2013 at 01:50 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Filtering an Access Report using a Form with VBA
    By krisels in forum Access Tables & Databases
    Replies: 3
    Last Post: 03-19-2013, 06:24 PM
  2. Form Email from Report, Only if Report summary sheet lists Acct for that Sales Rep
    By lukep10 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-28-2008, 01:38 PM
  3. [SOLVED] saved worksheet opens in new with macro error report
    By margaret in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-19-2006, 07:00 AM
  4. Access.Application.Quit - opens Access again then won't close - He
    By Hluhluwe in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-30-2006, 07:20 AM
  5. [SOLVED] Excel opens with an error report whenever I Boot Up my computer
    By Carl T in forum Excel General
    Replies: 0
    Last Post: 11-19-2005, 01:10 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1