2 continuous Forms

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
 
S

strive4peace

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 :)
*
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtering Data by Number Range 1
Help witha a query 1
Continuous Form Control Setting (Select Case) 0
Continuous Subform within a Continuous Form - Possible? 2
Autonumber (Using Dmax) on Continuous Forms 1
Problem with two Continuous Forms on one table 1
Query to extract the last sale from a company by date 0
loop through continuous forms 6

Top