Dynamic Text Boxes in form

[tc1]

Hi Everyone,
I have a table to enter dimensions for each part no. I have rows as part numbers and columns D1 to D100 for dimensions. Now, users dont need to caluculate all dimensaions for all the parts. I have another table where engineer can enter values that says which dimensions to calculate for users.

Now I am trying to create a form with dynamic textboxes that should be update depending on engineers table. If he says he needs D1,D2, then form should show only two textboxes D1 and D2. If he says D4,D15,D39 then form should show only those 3 fields.

Is it possible to do this?

Thanks in advance.

 

[John Big Booty]

The short answer is Yes.

What you will need to do is have a subform that is based on a query that will identify which of the dimensions the engineer has selected for a particular part. The query/subform will of course need to be required every time a dimension is selected/deselected.

 

[tc1]

John, Thanks for previous reply.
I was trying to create a subform that can update the fields based on SELECT query. I was a able to display a table which shows current dimensions selected for a perticular part in subform. But how do I show textboxes based on data entered?

 

[Luddite Lad]

You need to force the query populating the sub form to requery when ever the selected dimensions are changed.