asked on

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.

ASKER CERTIFIED SOLUTION

Jeffrey Coachman

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

kerikeri

ASKER

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.

Jeffrey Coachman

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?

kerikeri

ASKER

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

Jeffrey Coachman

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?

kerikeri

ASKER

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!

Jeffrey Coachman

ok...
;-)