How can I show a query results in a form in MS access?

Question

I'm building a database for a friend and most of it is finished, however I want to build a good GUI for the database.

Basically, when a query is run, I want the results to be shown in a form.

How can I do this?

Answer 1

When building your form, set the data source = the query name. Then you can either use a form to display a single record, continuous forms to show all records, or you can spit it out in datasheet mode.

Most of these settings are in the Properties window of the form.

Good luck.