I have a subform datasheet, with the following columns...
Category Product Price
Category and Product columns are both comboboxes. The rowsource for Products depends on the selection in the catagory combobox, however when i requery the product combobox, it requeries for all records on the datasheet, not for the current record, causing data to 'disappear' from other records.
Is there a way to prevent this from happening? I tried making the form in continious form view with the same results. Please help!