Display Unrelated Data/Information

  • Thread starter Thread starter comish4lif
  • Start date Start date
C

comish4lif

I have some forms that displays related information based on a single
member - the records of interest are displayed in a "continuos form"
with some summary data in the Form Footer.

For comparison purposes, I also want to display some organizational
data on the same form - the header or fotter would work equally as
well. For example, showing how a member's sales compare to the overall
organization.

I created all the organization metrics in their own form.

I tried to just paste in the data elements into the header, that didn't
work. And when I try to insert the form as a subform, it prompts me to
relate the subform to the form. It's not related. I just want to
display some data that is not directly related.

Is my question detailed and well-formed enough to be answered. Am I
missing something simple here?
 
It is not required to link the data between a form and a sub form. I do it
in a couple of places. I have one form that has no data of its own. It has
two subforms. One is bound to a query that returns editing errors from a
table. The other uses one of 4 different subforms the user choses through
command buttons to help determine how to fix the errors.

All you need to do is put a subform control on your form and either create
the subform there or identify an existing from to be the sub form. My
practice is to create my subform first, then create the subform control on
the mainform and identify my subform.
 
That's it - I knew I was missing something (somewhat easy). Use the 2
forms as subforms in a new form. Got it. It works now, thanks a bunch.
 
Back
Top