subreport

[Guest]

Hi,

New to Access. I am adding a subform but it isn't doing quite what I want.

1) I would like the form to recoginize an excisting address for those that
excisit and appear ( all address fields).

2) even if I type random detail (testing) when printing the subform detail
does not excist.

Please help

 

[Larry Linson]

First, remember there are differences in the way Subform and Subreport
Controls work. A big difference is that you can embed either a Form or a
Report in a SubForm/SubReport Control on a Report, but only a Form in the
SubForm/SubReport Control on a Form.

Second, to be strict in terminology, Access has no object known as a Subform
nor as a Subreport. It has Subform Controls and Subreport Controls that can
be placed on a Form or Report, in which you can embed an Access Form or an
Access Report, or show data in datasheet view. That said, we often take a
verbal shortcut and refer to these as Subforms and Subreport; but sometimes
the distinction is important in an answer.

New to Access. I am adding a subform but it isn't doing quite what I want.

1) I would like the form to recoginize
an excisting address for those that
excisit and appear ( all address fields).

I'm not sure what you mean by "form to recognize an existing address...".
What are you trying to display in the Subform Control, and how are you
linking/synchronizing the Form/Datasheet in the Subform?

2) even if I type random detail (testing) when printing the subform detail
does not excist.

I hope you will clarify the same issues regarding your Report, as I asked
you to clarify about the Form.

Perhaps, with the clarification, someone can be of assistance.

Larry Linson
Microsoft Access MVP

 

[Guest]

FYI, in the tool box it reflects subform/subreport, hence that is why I
referred to that term. Anyway, I figured it out I added the list box
(created via another table "address table") to the form and then added a
subform to my form reflecting all of the address fields with the exception of
the address name. When selecting the addressee (name) from my list the
address appeared.

Thanks anyway for attempting to make me feel inadequate instead of
understanding/willing to assist. Thank god I have had good
experiences/responses prior to yours!