Displaying queries

[FadingAPE]

Hello,

I'm creating a "search engine" for my database. I have everything set up in regards to the code etc and at the moment when searching a keyword it opens another form to display the results - I want it all on one form. Does anyone have any help on this at all or could direct me to a website that offers this info. Ive had a look around and not getting far!



Thanks

[NoellaG]

Hi,

Why not show the result in a subform of the searchform? Or put the search boxes in the header of the form, show the results in the detail section?

grNG

[FadingAPE]

Thanks. I did think that however when i sent the cmd button to open form it still opens up the other form. How to I get it so it stays on my main page and just changes the subform? Would I did to create a macro??

[NoellaG]

First build the correct SQL statement according to the choises the user has made, then put as the on-click event code :

Me.[Name subform control].Form.RecordSource = " ..put here your sql statement.."