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

Repeating Information on a Form

P: n/a
I have created a query which returns a single record. I then display the
four fields returned by the record on my form. I would like to display the
same record three times with only the record number changing. Can this be
done with Access 2000? I'm thinking that I would need some kind of VBA loop
or something.

I am open to any solution that will display three lines of identical
information taken from a single record of a query result. Thanks.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200710/1

Oct 9 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
dufnobles via AccessMonster.com wrote:
I have created a query which returns a single record. I then display the
four fields returned by the record on my form. I would like to display the
same record three times with only the record number changing. Can this be
done with Access 2000? I'm thinking that I would need some kind of VBA loop
or something.

I am open to any solution that will display three lines of identical
information taken from a single record of a query result. Thanks.
I might open the query as a recordset then set the Form's default values
to the values from the query.
Oct 9 '07 #2

P: n/a
Thanks Salad,

The only problem is the number of lines varies depending on how the user
arrives at the form. Sometimes I may need to repeat the line three times, or
I might need it to repeat ten times. That's why I trying to find out if I
can add looping code to loop based on a pre-determined value. Maybe this is
just wishful thinking...
Salad wrote:
>I have created a query which returns a single record. I then display the
four fields returned by the record on my form. I would like to display the
[quoted text clipped - 4 lines]
>I am open to any solution that will display three lines of identical
information taken from a single record of a query result. Thanks.

I might open the query as a recordset then set the Form's default values
to the values from the query.
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200710/1

Oct 9 '07 #3

P: n/a
dufnobles via AccessMonster.com wrote:
Thanks Salad,

The only problem is the number of lines varies depending on how the user
arrives at the form. Sometimes I may need to repeat the line three times, or
I might need it to repeat ten times. That's why I trying to find out if I
can add looping code to loop based on a pre-determined value. Maybe this is
just wishful thinking...
I don't understand. If you are "adding" 1 to 1 billion records, the
default value will alway be the same...until you move to a another set
of records. Set the fields to enabled/locked so changes don't occur.

moves to new record...set new values
Set rst = Currentdb.openrecordset("Query1",dbopensnapshot)
Me.Text1.DefaultValue = rst!Field1
Me.Text2.DefaultValue = rst!Field2
Me.Text3.DefaultValue = rst!Field3

Did you want to overwrite existing data? Then set the values in the
OnCurrent event.
>

Salad wrote:
>>>I have created a query which returns a single record. I then display the
four fields returned by the record on my form. I would like to display the

[quoted text clipped - 4 lines]
>>>I am open to any solution that will display three lines of identical
information taken from a single record of a query result. Thanks.

I might open the query as a recordset then set the Form's default values
to the values from the query.

Oct 9 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.