Base the form on the query exactly the same way as a table. If it already
exists, change the controlsource of each control (textbox, etc.) using the
property sheet's data tab.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads http://www.datastrat.com http://www.mvps.org/access
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.