2 continuous Forms

  • Thread starter Thread starter Maracay
  • Start date Start date
M

Maracay

Hi guys,

I Have 3 forms, the main form holds 2 to continuous forms, in the first one
the records are unique, and in the second one the record can occurs several
times lets say
First form
1 Company1
2 Company2
3 Company3

Second form has companyID plus Sales RepID
1 1 Mike
1 2 Sara
1 3 Jose
2 4 Sam
2 5 Rose
3 6 Mark
3 7 Karl
3 8 Earl

What I want is, when I click on the company2 from the first form just see
Sam and Rose and the same with the other companies, I can’t use the child –
father because both are continuous forms.

Any help will be appreciated.

Thanks
 
Hi Maracay,

you CAN put a continuous form on another continuous form as long as the
subform it is in the header or the footer of the main form. Access will
complain and tell you that a continuous form cannot have another one,
but just change it back :)

then you can use LinkMasterFields and LinkChildFields to synchronize
them <smile>

Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day :)
*
 
Back
Top