Sample Search Form

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.

Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

als315Connect With a Mentor Commented:
May be you can give more details?
You can find a lot of examples:

Do you need something specific?
PipMicAuthor Commented:
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.

It is standard for Access forms. You can download many Access templates from this page:
Northwind DB has demonstrated most Access abilities:|
The new generation of project management tools

With’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Jeffrey CoachmanMIS LiasonCommented:
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

PipMicAuthor Commented:
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.
PipMicAuthor Commented:
Good reference
All Courses

From novice to tech pro — start learning today.