Continious forms

  • Thread starter Thread starter Warrio
  • Start date Start date
W

Warrio

Hello!
Access doesn't allow to have a continuous form that contain a subform..
what I want to have is a list of Clients and for each one of them, have the
list of their different addresses:
_____________________
Client 1
address 1
address 2
address 3
_____________________
Client 2
address 1
address 3
_____________________

Is there anther way to group by the records by the ClientID and then by the
addresses?

Thanks for any suggestion.
 
Look at the Customer Orders form in Northwind; it does what you want. Look
at how the two subforms are set up.
 
What Northwind db does is what I have, but what I want is to have the list
of the customers on a continious form not on a singl form like in the
custumer orders.

so if anyone has a suggestion. and using a datasheet doesn't look that good
 
Here is the answer....

-------------------------------------------
One way this is commonly handled is to put both forms as continuous
subforms on an unbound main form, with the Link Master Fields property
of the second subform pointing to the linking field in the first
subform. Another approach is to put the second form as a subform in the
form footer section of the first form. In both cases, the end result is
that the secondary form will show data related to the current record on
the primary form.
 
Back
Top