Filter One Subform According to Another 1

[mkallover]

I've been trying to figure out how to do this and I can't seem to wrap my head around it. I have a main form with two subforms that display in datasheet mode on it. Neither of the subforms is linked to the main form in any way.

The first subform is a list of projects (frmSubProjects). Each project is identified by a field called 'CPOProjectNum'. The second subform is a list of updates (frmMainUpdates). Each update can be linked to the corresponding project through the CPOProjectNum.

What I would like to do is have frmMainUpdates be filtered according to whatever record is selected in frmSubProjects. However, I have double-click events on many of the fields in frmMainUpdates so I'm not sure that using an onclick event would be the way to go?

I'm not sure where to even start on this one. Any suggestions would be greatly appreciated. Thanks.

 

[Remou]

Have a look at the Customer Orders form of the Northwind sample databse. I think it does exactly what you want.

 

[mkallover]

Yep, that's what I wanted. Thanks Remou.