to create text boxes based on user input

[sunilvedula]

Hi all,

I have form which is designed based on a word template. I want text boxes to populate based on user input. For eg if user says 5 then i want 5 text boxes to populate. Is it possible? Even if possible how do i ensure that when user submits it it gets submitted in the table.

 

[Galaxiom]

This looks like a cut down version of your original post where the problems with creating text boxes in this way are explained.
http://www.access-programmers.co.uk/forums/showthread.php?t=180821

Your goal seems ill-defined. If the user says 5 it is easy to have five text boxes visible but how do you propose to select which fields they are bound to?

 

[gemma-the-husky]

lets start again

what are you trying to achieve with these text boxes?

 

[sunilvedula]

ok first of all sorry for the repost. I thought that the earlier post was never posted as i had issues with the internet. Anyhow will explain. There is a form in excel which bank employees fill and send it to another region. Now in this form they enter details of multiple transactions. some times it might be required to enter say 10 to 50 and sometimes only 1 (depends on different scenarios) and in excel they go on adding multiple lines as and when required. I have designed the form as it is in excel kind of replicated it. now i have issues with adding mulitple line in our case i require adding text boxes so as to fill them with info as and when required.