requery function clearing forms items

K

kalman

i build an ordering system based on order form and
detail subform where the user choose items from
catalog
To limit user looking up in "big" catalog I have a pre-choice combo
where
he can limit his choice in specific item family

What happens is whenever I choose a specific item family all already
selected items on form (from different family) become blank !!!!
I assume this is due of requery function I had to use for the cascaded
combo.
Any urgent help to get get out of this problem.

Thanks

Kalman
 
Top