a special type of search form

D

Dr Poot

I used a database a while ago and it had this function which I'll explain
below - I'm wishing to be able to create it, although have tried a number of
ways with no success.

This is a form which is used to locate specific records. At the bottom of
the form would be a list of every record in the database, where if one
clicked on any record, a specific form would open up, displaying the
extensive information on that record. At the top of the form there were
several fields where one enters in the values they wish to match from the
data in the database (eg name, date, company, etc), each of them having a
button next to it to update the list below, hopefully to cull it down to a
few so that one can be selected from simply inspecting which is relevant. It
sounds like a filter set up, but I'm not sure how to set this up. Nor do I
know how to have it so you could dbl click on one of the records in the list
to open up a form displaying the more extensive details.

This may sound confusing, I hope it isn't too bad, coz I hate reading long
things, so thanks if you got to here. Any ideas, as you may tell, would be
greatly appreciated. Thanks

- Matt
 
Top