Creating Multiple input rows on a form

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

Re: Creating Multiple input rows on a form

"dufnobles via AccessMonster.com" 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

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/

Re: Creating Multiple input rows on a form

On Oct 18, 3:20 pm, "dufnobles via AccessMonster.com"
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.

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.com
http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-ac cess/200710/1

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.com"
>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/Forums.aspx/databases-ms-ac cess/200710/1

Re: Creating Multiple input rows on a form

On Oct 18, 4:00 pm, "dufnobles via AccessMonster.com"
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"
> >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.asp x/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.

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.com"
>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.asp x/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

Re: Creating Multiple input rows on a form

"dufnobles via AccessMonster.com" wrote:

>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.

So far there is no reason not to use a child table and sub forms. Do a search on
subforms in the help. A subform is usually a continuous form anyhow.

What kind of data are you trying to model? Is there data in a parent table? A
classic example is invoices with invoice details. The invoice is the parent table
and has data such as customer ID, date, invoice number and so forth. Invoice
details. of which you can have as many or as few as you want, will have details such
as item ID, quantity and cost and price at time of invoice.

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/