I've managed to filter a combo box, so it only shows a list of products produced by a manufacturer once the manufacturer is selected in a previous combo box.
I have a datasheet on a form to show assets owned by a particular owner, but my problem at the moment is if i select a different manufacturer to enter the existing products the owner hold blanks out. I think its to do with the limit to list property as obvious different manufacturers are going to have different products therefore when other manufacturers are selected it blanks those not in the new requeryed list out. any sugggestion on how i can resolve this???
hope that makes sense its kinda hard to describe - attachment to illustrate