Subform isn't displaying current record, please help

[amygamet]

I looked through the old threads and saw a lot of similar questions, but nothing helped. If you could shed some light on this I'd appreciate it.

I have one main form with two sub forms, each form is linked in a one-many relationship. In other words, CUSTOMERS have muliple jobs, and JOBS have multiple pieces of EQUIPMENT.

When I pull up a CUSTOMER I get all the related JOB information (which is good), but I also get all EQUIPMENT that's related to the CUSTOMER regardless of whether or not it's related to the JOB I've selected (not good).

I've tried checking my master/child relationships, my record sources.... I've recreated the form as a "nested" subform--one inside the other. Nothing's worked. I don't know any SQL, which may be part of my problem. Would GREATLY appreciate any advice you may have!

 

[Darrylles]

Hiya amygamet,

Firstly, what ARE the relationships?
They should be:

CUSTOMERS --> JOBS --> EQUIPMENT

where the arrow head points to the 'many'.

Secondly, Customers is on the main form, Jobs is a subform on the main form (Customers), and Equipment is a subform on the JOBS subform.

Have you got this or have you painted the Jobs and Equipment on the Customers form?

Regards,

Darrylle "Never argue with an idiot, he'll bring you down to his level - then beat you with experience."

 

[amygamet]

Thanks for the help... I got it working now. Apparently I had a problem with my recordsource property. I fixed it a while ago, but I didn't recreate the form, so it didn't have any effect until I did that. Thanks again!