create a form from a report?

B

Bill C-R

i inherited a databse that has a report using a select query as its record
source, so it is displaying the underlying table. i want to create a form
that is laid out like the report, using the same query as its record source,
so that can scroll thru the table and edit fields as necessary. short of
creating a form from scratch absed on the query, can i use the report design
as some sort of template to create a form?
 
L

Linq Adams via AccessMonster.com

You can save a form as a report with a couple of clicks of the mouse, but not
vice versa. I suppose you could, in Report Design View,goto Edit - Select All,
then Copy. Open a new form in Design View, select the same query as the
form's Record Source, then Paste everything in. You might have to tweak the
form a little, but you wouldn't be starting from scratch.
 
Top