Creating a Search Form

[zandiT]

Hello everyone

i have a mainform called frmMain and it has 2 subforms. the frmMain consists of 2 combo boxes. i want to create a search form whereby the user can choose an option in combo1 and in combo 2 then the matching record appears in the subforms . i tried using the find button in access but the search form is too confusing for users so i would like to create a form that is more straight forward. your help is greatly appreciated.

[Stewart Ross]

Sorry ZandiT, but it really isn't practicable for us to advise you of how to create a search form when we have no knowledge whatsoever of your application. If you could narrow down what it is you are seeking advice upon we may be able to help - but this is just too vague for us to assist.

-Stewart

[NeoPa]

See Example Filtering on a Form for something that uses the concept of filtering for a separate form. You would need to read it and then convert it to apply a filter to the subform.