[AccessD] Related combos in a datasheet

Arthur,

I am not sure about datasheet, I don't have any experience with that. 
But in a contunuous form you can do code like this, on the Enter event 
of the second combobox:
   Me.SecondCombo.RowSource = "SELECT whatever FROM YourQuery WHERE 
YourField = " & Me.FirstCombo
... and then on its Exit event:
   Me.SecondCombo.RowSource = "SELECT whatever FROM YourQuery"

This will not work if you use the traditional Requery of the second 
combobox on the After Update of the first.

Regards
Steve


Arthur Fuller wrote:
> Has anyone figured out how to make related combos work in a datasheet form?
> They work fine in a single form, but in a datasheet they have a problem, in
> that redefining the second combo's row source screws up the display of the
> other visible records.
> 
> TIA,
> Arthur