Results 1 to 2 of 2
  1. #1
    Briansa is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Sep 2012
    Posts
    1

    Main form running a search on Subform

    Hey all,
    I know this a simple question and probably answered before but im missing something. I have only 1 table that im working with I simply want to have a form that runs a search on one of the fields and returns the results.

    This is what I have:
    1 Table

    ID : Autonumber
    ProblemType : Text
    Technician : Text

    I want to create a form that has a main form with a text field that i can input a string of text and run a search on the problemtype field. And return all the results in the subform with based on keyword that was inputed in the form above. I want the results to display Problem type and Technician fields. What is the best what to do this?

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,726
    see if this video helps
    http://www.datapigtechnologies.com/f...earchform.html

    I don't think your set up is what we would normally call main form/sub form.

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

Similar Threads

  1. Replies: 3
    Last Post: 08-22-2012, 03:28 AM
  2. Search Main Form Based on Contents in Subform
    By MintChipMadness in forum Forms
    Replies: 1
    Last Post: 08-09-2012, 02:45 PM
  3. Replies: 4
    Last Post: 07-11-2012, 10:31 AM
  4. Replies: 3
    Last Post: 04-17-2012, 10:28 AM
  5. Replies: 13
    Last Post: 01-29-2012, 01:45 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