Simple Form question

  • Thread starter Thread starter tom
  • Start date Start date
T

tom

I have a one to many subform. I would like the subform
to display all the records that link to the record on the
main form, but the subform stubbornly only displays
one record. Also the subform stubbornly displays
a smaller detail section when displayed in the main
form than when opened by itself.

I also have some calculated fields in the footer of the
subform. I assume that solution is simple but eludes
me for the moment.
 
Have you checked to make sure the Default View of the subform
properties is set to "Continuous" or "Datasheet" (depending on what you
want for the form)?

~J
 
Been there tried all that. Doesnt do what I want.
Data sheet would do what I want but than I cant
get the calculated controls on the form footer.
 
* Check you settings for the LinkMasterFields / Link ChildFields.

* Check that the Form being used as the Subform has been set to use
ContinuousFormView or DatasheetView as the DefaultView.

* The Subform or more correctly, the SubformCONTROL is contained within the
Main Form. The SubformControl (which contains the "Subform") can only
occupy the space as you set in the DesignView of the main Form unless you
change the dimension of the SubformControl by code. Note that the CanGrow
Property of the SubformControl is for printing only, not for displaying the
Form on screen ...
 
Back
Top