Search

[turnej]

I have created a db with several forms linked by a autonumber ui, I wish to create a search function that will pull records from the database and ideally display the results on a form as opposed to a data sheet - any ideas on how best to approach this?

 

[CJ_London]

It is certainly doable but you need to be clearer about what you actually want to do since there are many possible solutions.

For example:

pull records from the database

Are you searching one table or many?
Are you searching specific fields, or all of them?
what type of search?
do you want to search by multiple criteria?
do you want to search on partial entries?
what information do you want to display as a search result?
How are you generating your criteria? user input, dropdown selection, multiselect listboxes, combination of two or more of these etc.

With regards the other part of your question

ideally display the results on a form as opposed to a data sheet

Use a continous form as a subform if you don't want to use a datasheet view is the easy answer but you may have alternative ideas