Search form which brings up all occurrences of a specific data entry

[swavemeisterg]

I'm relatively new to Access so I could use all the help I can get.



Basically I have a table which holds as entries specimens and actions taken on the specimens.

Because of that, there could be multiple entries under the same serial number.

What I would like to do is have a search form, in which the user enters the serial number, and a list appears for all of the entries with that serial number.

I figure this is a pretty common request, so there's gotta be a way to do it simply.

I am a beginner for access, but I understand VBA pretty well so no need to sugarcoat.

Thanks!

[JeroenMioch]

I would use a filterform

You can put in any criteria you want, and make combinations of them.

So if i was looking for samples that has serialnumbers "ABC" in them (wildcarded) and were dated before lets say "01-01-2011" it would return all records with those criteria.

if its just the one field you want to query then there is an easier way.
But if you want combinations to query then i use the filterForm method, wich never failed me to date

In the link below there is some info about it :

https://www.accessforums.net/forms/f...tml#post122348

[swavemeisterg]

How will this display the results?