Hi, I am trying to design an inventory for a shop that sell shoes.
Everything works fine I only have one question, if somebody can help.

I need to have a single form to display the quantity avalabile of a certain line of product, taken from a query. I created the continous form, the filter and everything is fine. Each record though, has to show all the size of a certain product. I used the dlookupfunction that has 2 variables (line and size) to show these records, and works fine. Problem is there are a lots of records so, unless I keep clicking more and more anywhere on the form they don't show.

So my question is

Is there another way I can show the stock in each size, quicker than the lookup, or is there a way I can make datas to show up quicker?

Thanks