Sample Search Form

Posted on 2012-09-07
Last Modified: 2012-09-11
Grateful if anyone can provide a sample of a simple or perhaps a not so simple search form  to spruce up my programme. Hoping to provide some innovation to my programme.

Question by:PipMic
    LVL 39

    Accepted Solution

    May be you can give more details?
    You can find a lot of examples:

    Do you need something specific?

    Author Comment

    Thanks, thats fine for a from a single table.

    I was perhaps looking for something more elaborate. Perhaps my description of a simple sample form was my mistake.

    My idea ( as an example) is of a Search form which will look up a client,  which will then produce a list of related records of that client, probably in a sub form within the main form.

    Then actually produce a report of that client with its related records.

    LVL 39

    Expert Comment

    It is standard for Access forms. You can download many Access templates from this page:
    Northwind DB has demonstrated most Access abilities:|
    LVL 74

    Expert Comment

    by:Jeffrey Coachman
    Are you saying that of the hundreds of examples here, you could not find a single sample?

    I did a simple search of:

    "Access Search form sample example", and on Google and got literally thousands of hits.....

    I am sure one of these could help you.

    With the amount of questions you have posted here, and the many great solutions yoy were given, ...I am sure you can take a sample "filter" ("Find a Record on a form", ...Access has a combobox wizard for this) and apply it to a Partent/Child (main/sub, ...Client/clientRecords) form.

    ...then use that to open a filtered report:
    Docmd.Openreport "YourReport", acviewPreview,, , "ClientID=" & cboClientID


    Author Comment

    Dear boag2000,

    Many thanks for your comments.

    Yes, you are correct a simple search does provide plenty of samples and Yes I do ask a lot of questions and Yes I have been provided with great replies which I have successfully implemented.

    But I do also pay a monthly subscription, for the assistance I require.

    Perhaps my questions annoy you but I am beginning to wonder if you have anything personal against me. If that is so, just simply ignore my questions .

    As regards my opening post I was merely enquiring to see whether anyone knew of additional or other search samples. That is all!

    There is, I do not think, any need for sarcasm or crticism in that form.

    Author Closing Comment

    Good reference

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
    A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
    Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

    730 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now