Access subform datasheet table query
Posted on 2009-12-19
I have a subform which displays records in the datasheet view. Two columns, Product and Amount, and roughly 20 rows. It is populated using sql when I select Department from a listbox on the same form. Data that is displayed in the subform is reviewed and if needed changed.
Because the subform isn't bound to a table, how can I grab all of the records in the subform and write them to a table I have specified? I'm trying to think of this in terms of "Select Product, Amount from subform" but cant get think of how to make this work.