By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,385 Members | 847 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,385 IT Pros & Developers. It's quick & easy.

Creating Multiple input rows on a form

P: n/a
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

Oct 18 '07 #1
Share this Question
Share on Google+
6 Replies


P: n/a
"dufnobles via AccessMonster.com" <u37896@uwewrote:
>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/
Oct 18 '07 #2

P: n/a
On Oct 18, 3:20 pm, "dufnobles via AccessMonster.com" <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.accessmonster.com
1st the form ACCEPTS data input. The easiest way to accomplish what
you want is to use a continuous form.

Oct 18 '07 #3

P: n/a
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.com
http://www.accessmonster.com/Uwe/For...ccess/200710/1

Oct 18 '07 #4

P: n/a
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.com" <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.accessmonster.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.com
http://www.accessmonster.com/Uwe/For...ccess/200710/1

Oct 18 '07 #5

P: n/a
On Oct 18, 4:00 pm, "dufnobles via AccessMonster.com" <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.com" <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.accessmonster.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.comhttp://www.accessmonster.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.

Oct 18 '07 #6

P: n/a
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.com" <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.comhttp://www.accessmonster.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

Oct 18 '07 #7

This discussion thread is closed

Replies have been disabled for this discussion.