Dynamic textboxes

[braddy]

Hi all

I'm doing an access application where you select a product and attach that product with an ordernumber and I also have a table like a library with different kind of measurements for the products.
Now what I need to do is selecting an ordernumber from my combobox and that should trigger an event, where Access helping me to count how many different measurements this product have.

Sometimes a product have only 1 measurement, weight for example and another product could have 7 different measurements.

First I thought lets do this programmatically and loop through and populate the form with a textbox for each measurement, but I realize this is not an option in Access.
I want to be able to enter data for all measurements, the thing is that different products require different amount of measurements...

Could someone please help me and guide me in this matter?

[ItsMe]

Have you tried building a query? You can create a basic select query with only the fields you are trying to count and a column that holds a Foreign Key. With that, you can turn your query into a Totals query and change the "Totals" field in the query from "Group By" to "Count".

Then you can join this query to another query to help you display the count in a form or report.

[braddy]

Thank you for your advise, I'll try it and get back to you.