Combo box values depends current record.

[Cass]

Hi!

I'm looking solution how to set combo box rousource so all previous records not depends current record.

Its something like this How To ...http://support.microsoft.com/?kbid=209595
BUT it works fine when i using form view but i need datasheet view.

etc. there are list of items one column and another i can choose several item groups where this item belongs and combo show only this record groups.
Now next record change combo recordsource for this item and all previous combo box depends on current record.

sry my bad english also.

 

[Guus2005]

I don't think you need datasheet view. Use a continuous form instead. I believe that will solve your problem.

HTH