can't add multiple record in subform datasheet view

  • Thread starter Thread starter toms
  • Start date Start date
T

toms

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 pushed in from
banging it on the keyboard.

Thanks again for any help/direction
 
Finally got it. The trouble was in a join between two
tables on the query. I took the subcategory combo out of
the datasheet design and everything was fine.
 
Back
Top