another combo box poulation challenge

[jlute]

I've got yet another combo box population challenge! This one involves
1 main form and 3 subforms. To keep things simple I'll simplify the
names:

[frmMain]
[sfrmResource].[ResourceID] - sfrm of [frmMain]
[sfrmLocation].[LocationID] - sfrm of [sfrmResource]
[sfrmLine].[LineID] - sfrm of [sfrmLocationID]

I hope that clearly illustrates the design. One thing to note is that
the 3 subforms are also used in several other forms but in the same
manner.

Here's what I'd like to populate:
[sfrmLine].[LineID] according to the value in [sfrmLocation].
[LocationID].

Here's the trick. The subforms are in datasheet view.

Can this be done? Or is it too complicated to bother with?

 

[Golfinray]

Check www.allenbrowne.com or Marting Green also has some good stuff on that
at www.fontstuff.com.

 

[jlute]

Thanks for the links. I'm familiar with Allen Browne but I'd never
visited Martin Green's site. Now that I have I can say that both are
superb resources.

I really couldn't find a similar example on Allen's site. Martin's
example is also much different than mine. His example is a rather
simple form with a couple boxes. Nifty but not at all like what I
posted here.

Checkwww.allenbrowne.comor Marting Green also has some good stuff on that
atwww.fontstuff.com.

I've got yet another combo box population challenge! This one involves
1 main form and 3 subforms. To keep things simple I'll simplify the
names:

[frmMain]
[sfrmResource].[ResourceID] - sfrm of [frmMain]
[sfrmLocation].[LocationID] - sfrm of [sfrmResource]
[sfrmLine].[LineID] - sfrm of [sfrmLocationID]

I hope that clearly illustrates the design. One thing to note is that
the 3 subforms are also used in several other forms but in the same
manner.

Here's what I'd like to populate:
[sfrmLine].[LineID] according to the value in [sfrmLocation].
[LocationID].

Here's the trick. The subforms are in datasheet view.

Can this be done? Or is it too complicated to bother with?- Hide quoted text -

- Show quoted text -