Hidding Fields Based on number

[avenger619]

Hi guys,

I search around online and did come across much info on code to how to hide fields.

but, the problem is I cant seem to find a way to hide a certain amount of fields based on a number amount.

example: Lets say I have a 12 text fields to show 12 months of monthly payments, and lets say a client only has a 3 payment term. How can I list 3 under installment field and have remaining 9 fields auto hide since they wont be necessary? this way I only see what applies and not additional text fields.

Any help much appreciated. Thanks

 

[missinglinq]

Many of us would do this using two Tables, one for the customer and one for payments. The Payment Table would be used as the RecordSource for a Form that in turn is used as a Subform to the Customer Form. You'd then be able to enter however payments you needed to for a given customer.

That said, if you're resolute in having the payment Controls all in a single Table with the customer data, the first question, I guess, would be are there possibilities for the number of payments being 1-12, inclusive, or is it likely to be 3 months, 6 months, and so forth?

Linq ;0)>