two dropdown boxes second dependent on first

[SAC]

I have two dropdown boxes and the second is dependent on the first one's
data. I do a requery on the second one on the form.

In datasheet view the columns all disappear as I requery. Any work around
for this?

Thanks.