Search forms and sub forms

[FadingAPE]

Hi,



I dont have a vast vb knowledge. I currently have a form set up in access that can qry my database and display the results on another page. What I would like is to be able to search and display on the same page. Can anyone help me at all please?

Thanks

[pbaldy]

One method is demonstrated in the sample db here:

http://www.baldyweb.com/BuildSQL.htm

It uses dynamic SQL; there are other ways.