Creating Multiple input rows on a form

[dufnobles via AccessMonster.com]

I have a form that excepts text input from a user. I would like to have the
form display the same line several times so that the user can enter several
different responses on one form screen.

How can I display the same line of identical textfields five different times
on the same form (each with a different line number)? Once this happens, how
do I insert all of them into the same table? Thanks

--
Message posted via http://www.accessmonster.com

[Tony Toews [MVP]]

Re: Creating Multiple input rows on a form

"dufnobles via AccessMonster.c om" <u37896@uwewrot e:

>I have a form that excepts text input from a user. I would like to have the
>form display the same line several times so that the user can enter several
>different responses on one form screen.
>
>How can I display the same line of identical textfields five different times
>on the same form (each with a different line number)? Once this happens, how
>do I insert all of them into the same table? Thanks

Why not use a child table and subforms? How do you know there will only ever be a
maximum of "five different times?"

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at

http://www.granite.ab.ca/accsmstr.htm

Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

[DavidB]

Re: Creating Multiple input rows on a form

On Oct 18, 3:20 pm, "dufnobles via AccessMonster.c om" <u37896@uwe>
wrote:

I have a form that excepts text input from a user. I would like to have the
form display the same line several times so that the user can enter several
different responses on one form screen.
>
How can I display the same line of identical textfields five different times
on the same form (each with a different line number)? Once this happens, how
do I insert all of them into the same table? Thanks
>
--
Message posted viahttp://www.accessmonst er.com

1st the form ACCEPTS data input. The easiest way to accomplish what
you want is to use a continuous form.

[dufnobles via AccessMonster.com]

Re: Creating Multiple input rows on a form

The number of records will vary based on prior user selection (I used five as
an example). I am able to get this part working.

The problem is once the proper number of lines are displayed, I am not sure
how to enter all of them onto the database. I have a save button which the
user can click after entering information for all the response entry lines.
Any ideas?


Tony Toews [MVP] wrote:

>>I have a form that excepts text input from a user. I would like to have the
>>form display the same line several times so that the user can enter several

>[quoted text clipped - 3 lines]

>>on the same form (each with a different line number)? Once this happens, how
>>do I insert all of them into the same table? Thanks

>
>Why not use a child table and subforms? How do you know there will only ever be a
>maximum of "five different times?"
>
>Tony

--
Message posted via AccessMonster.c om

http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200710/1

[dufnobles via AccessMonster.com]

Re: Creating Multiple input rows on a form

I don't want to sound stupid, but what is a continuous form and how does it
work? I'll be happy to research more info on this, but this is the first
time I have ever heard of it...

Would this be better than the previous suggestion of using the child table
and sub forms?


Thanks.

DavidB wrote:

>On Oct 18, 3:20 pm, "dufnobles via AccessMonster.c om" <u37896@uwe>
>wrote:

>I have a form that excepts text input from a user. I would like to have the
>form display the same line several times so that the user can enter several

>[quoted text clipped - 6 lines]

>--
>Message posted viahttp://www.accessmonst er.com

>
>1st the form ACCEPTS data input. The easiest way to accomplish what
>you want is to use a continuous form.

--
Message posted via AccessMonster.c om

http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200710/1

[DavidB]

Re: Creating Multiple input rows on a form

On Oct 18, 4:00 pm, "dufnobles via AccessMonster.c om" <u37896@uwe>
wrote:

I don't want to sound stupid, but what is a continuous form and how does it
work? I'll be happy to research more info on this, but this is the first
time I have ever heard of it...
>
Would this be better than the previous suggestion of using the child table
and sub forms?
>
Thanks.
>
DavidB wrote:

On Oct 18, 3:20 pm, "dufnobles via AccessMonster.c om" <u37896@uwe>
wrote:

I have a form that excepts text input from a user. I would like to have the
form display the same line several times so that the user can enter several

[quoted text clipped - 6 lines]

--
Message posted viahttp://www.accessmonst er.com

>

1st the form ACCEPTS data input. The easiest way to accomplish what
you want is to use a continuous form.

>
--
Message posted via AccessMonster.c omhttp://www.accessmonst er.com/Uwe/Forums.aspx/databases-ms-access/2007...

Better is often a matter of taste and preference (how one defines
better). Simpler yes... Better all depends on the full intended use
and what you prefer. Continuous forms are described in the built in
help.

[dufnobles via AccessMonster.com]

Re: Creating Multiple input rows on a form

Thanks David,

I can appreciate your response. I'm headed for the built in help...

DavidB wrote:

>On Oct 18, 4:00 pm, "dufnobles via AccessMonster.c om" <u37896@uwe>
>wrote:

>I don't want to sound stupid, but what is a continuous form and how does it
>work? I'll be happy to research more info on this, but this is the first

>[quoted text clipped - 18 lines]

>--
>Message posted via AccessMonster.c omhttp://www.accessmonst er.com/Uwe/Forums.aspx/databases-ms-access/2007...

>
>Better is often a matter of taste and preference (how one defines
>better). Simpler yes... Better all depends on the full intended use
>and what you prefer. Continuous forms are described in the built in
>help.

--
Message posted via http://www.accessmonster.com