How do I show Query Results on a Subform instead of a Datasheet view.

[ChrisBush]

I'm building a database that holds a lot of Lessons that are taught at a university. Currently, I have a form with labels, text fields and a button that runs my search query. So for instance if a user entered 'Java Programming' into the Lesson Name text field and clicked search, the query would run and all of the lessons with that name would be displayed into a datasheet view. My question is, how do I get these results to display on a sub-form when I click my run query/search button on my main form instead of them being shown in a datasheet. Thanks.

 

[rs2k]

Build your sub-form off the query.

In the sub-form 'properties' on the 'Format' tab change the 'Default View' from DataSheet to whatever you want.

HTH

Colin

 

[merlin777]

I cant see a default view on the subform properties format tab. are there any extra steps?