Query Show Results on Form

[john226]

Hey,



I have set up a query to search the books table by their own unique id.

however when this search has been completed the results are shown in the table and not on the form where the button is located? What am i doing wrong that its not showing on the form?

Thanks.

[kennejd]

Perhaps you can post your code? Maybe your form just needs to be requeried?

[john226]

Not sure what you mean by code however, its a simple query searching through only one field with the criteria set as [Search Book ID]. What I'm saying is the results from the query are shown in a table, is it possible to show these in a form where the button of the query is located?

[kennejd]

You can put a subform on your form. Make the controlsource of the form...the results table. Requery the subform after you click the button.