Advice on search filter/form

[optionone]

Hi,

Have built a (clinical) database that links 2 main tables (a patient register table and a hospital dates/info table) - the staff using it require some means to search on multiple fields and these fields would be present in either of the two tables

Came across the 'filter by form' (http://support.microsoft.com/kb/262099) page but it seems this is specific to one form? Would this be the best option/idea for me? Guess I could create a new form from a query that links the two tables and go from there or is there some other way?

Thanks!

 

[CBrighton]

Creating a form based on the query sounds like a winner to me.

Personally my search forms are unbound and I create a string in VBA which creates the filter criteria based on various controls (screenprint of search form: http://www.access-programmers.co.uk/forums/attachment.php?attachmentid=35733&d=1297174868). In my case this example is to set the criteria on reports, but equally it could open a form.