I was wondering if anyone could explain to me how to read a dataset into a form that is in dataset view and the form is unbound. I want this form to be used as a sub form and be filtered based on list box from the main form.

 

jd erd

__________________
jd erd

One usually does that with a query. Is there a reason you can't use a query? Otherwise put it in a temporary table, and base the subform on the temp table.

HTH

mmcdonal

I never thought of using a query to open a data sheet view. the reason I want to do it that way is because the main form is unbound and each customer has multiple rations and each livestock ration is loaded into the list box to choose from so basically when the user selects the ration from the list box it loads the actual ration of products and quantity. The only thing is I wish to be able to have the products in a list box on the data sheet view so they may be able to add or delete products :)

jd erd