Create a form from table record

[ande8698]

I am using MS Access 2010. At my office we enter all of our data directly into a table and do not use a form for data entry. What I would now like to be able to do is print out a form showing all of the data for one record. Any suggestions on how to accomplish this would be greatly appreciated!

Thanks

[June7]

Report would be better object for printing.

A parameterized query as form or report RecordSource is one way to limit the output. The parameter can be a popup input or reference a control on form. Review http://www.datapigtechnologies.com/f...mtoreport.html

However, I never use dynamic parameters in queries. I prefer:

DoCmd.OpenReport "report name here", , , "ID=" & Me.controlname