can't add multiple records in subform (datasheet view)

[tstuve]

Thanks in advance for helping me with this:

I've been trying to get a subform in datasheet view to
add records to a query. I've got a subcategory combobox
(unbound)which allows the user to select a product
subcategory. A product description combobox is then
populated by all the products in the selected
subcategory.

Here's the problem:

the comboboxes populate just fine and can be selected,
but as soon as I select a product description, another
row is added with the same subcategory as the first. If I
change either subcategory combobox, both of them change
to the same thing. In short, I cannot add multiple
products. I've recreated the subform several times,
amongst many other things. My forehead is now permanently waffled from
banging it on the keyboard!

Thanks again for any help/direction

 

[tstuve]

I finally got it. The trouble was with a join in the query. I took the subcategory combo out of the datasheet design and put it off to the side. Everything worked fine then.