Create an input form from an existing report

I've created a report with a subreport.  The format is perfect, and now I would like to simply create a form, exactly the same, where the existing data can be modified.  Sounds simple, but I'm not having much joy!  Thanks for any advice.
kerikeriAsked:
Who is Participating?
 
Jeffrey CoachmanConnect With a Mentor MIS LiasonCommented:
Unless your Report is very simple, ...it may not be a simple thing to make an "Exact" form from it...
(Be aware that typically the form is created first)

But here is a way to do what you have asked:
Open the report in Design View
Press: Ctrl+A  (to select all of the objects on the report)
Create a From in design View
Press: Ctrl+V  (To paste all the report objects into the form.)

Again, ...it may not be as easy as you had hoped, ...as Reports and forms serve two different purposes.
So the recordsource for the main form may not have came along with the copy/paste.
You may have to manually set the Recordsource property of the main form to the same table (or query) as the main Report.

But again, ...this is highly unusual, ...and I don't recommend doing this...
As I stated, typically the form is created first ...then the Report.
(the form may not operate or display in the way you might expect either...)

Hope this helps...

JeffCoachman
0
 
kerikeriAuthor Commented:
Thank you for your quick response Jeff, much appreciated.  I've decided I'm going to add a command button to the 'main' form that opens the 'subform' . I've just tried the copy and paste suggestion, no can do.
0
 
Jeffrey CoachmanMIS LiasonCommented:
Still confusing...
I'm going to add a command button to the 'main' form that opens the 'subform'
There is no real need to do that.
In a typical main/subform, the subform is always visible.

What the need for a button to open the subform?
0
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

 
kerikeriAuthor Commented:
Thanks for the follow up comment.  It's urged me to document what I've done.  See attached.  I can't figure out how to have a subform within a continuous main form, which is what is required.  So this is my work-around.
EE-Explanation.docx
0
 
Jeffrey CoachmanMIS LiasonCommented:
What is your skill level with Form/report design?
In most cases it is not necessary to create two queries,
...All you need is one query that joins both tables...

Also I don't see a need for a Continuous main form and a continuous subform. (because Access does not allow this)
What is typically done is that you have a continuous form (Bridge)
Then make a "popup" continuous form for the Roads
(If I am understanding correctly...
But you will need a fair amount of code to get this to work right.

Why cant a standard main/subform work for you?
0
 
kerikeriAuthor Commented:
I've had some years of form/report design, but still am learning.  However, in this case, I'm going to stick with the command button as it displays the data in the same format as the Report document.   Thanks again, I'm always impressed with you Experts' generosity!
0
 
Jeffrey CoachmanMIS LiasonCommented:
ok...
;-)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.