Displaying search query results on a form

[Barnie]

How would i get a queries results to go to the correct fields on a form
rather than as a table?

 

[Arvin Meyer]

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

 

[Sprinks]

Use the Openform method using the optional FilterName parameter. See VBA
Help for complete syntax (<Alt-F11>, Help, search for "Openform")

Sprinks