Cascading Combo Boxes in a Datasheet or Continuous Form

[dancole42]

So I have two combo boxes on datasheet, cboProduct (a list of software products) and cboRelease (a list of releases, with each product having its own set).

When you select a product from cboProduct, then cboRelease updates to show only releases tied to that product. The rowsource of cboRelease is a query whose criteria is ReleaseProduct = [Forms]![myForm]![cboProduct], and the AfterUpdate event of cboProduct and the onLoad event of the form requery cboRelease so it updates with relevant releases.

Pretty basic, right?

The problem I'm running into is that when the form loads, or when I select a product from cboProduct, then EVERY instance of cboRelease on the datasheet (or continuous form) updates to the selected cboProduct (i.e. is blank for ones that don't match).

Any ideas?

Thanks!

 

[Galaxiom]

That is because they are the same object. If you change the properties of the object then of course every instance will change.

There are ways around it but they are very complex. Basically you need to pop up a small form with a combo right on top of the combo that is being edited.

 

[John Big Booty]

The sample posted here operates in the manner suggested by Galaxiom