specifying number of text fields

[Astro]

hello, can anyone shed some light on how to go about working on this.
i.e, user will be allowed to specify the number of textfield/s to be displayed in the next form. thank you very much.

[Ecniv]

Possibly you could have a maximum number of fields, then create a form with all the fields.
As you open the form from a button click, you pass the number of fields in the openArgs part of the DoCmd.openform.
Your form takes the number (defaults to say 2 fields) and makes any of the other text fields invisible as the form opens/loads.
Won't be too helpful if it is bound, but should still work.

There are probably other ways to do this.

[Astro]

Thanks man Vincent! =) Sorry for the late reply!

[dannymking]

Another way to do this would be to show the user the fields that are available and allow them to select those that they want including in the next form..

Those that are not selected can just be set to hidden, this way your resulting form can be bound (providing all fields are not set to required)