A query. when opened, is only going to display data in what you're calling a
"datasheet" view. To have the data displayed as a "form" view, as John said,
you need to "design a form in continuous view with your query as the form's
record source. Then you open the form (which will automatically
execute the query)."

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...arted/201005/1