showing two records on the same form

[Guest]

I have a two record table with multiple colums. One record is a current
record and the other is the new record. I would like to display both the
current and the new record on the same form to show the changes for each
field. Any thoughts on how to perform this.

Thanks

Tony

 

[Duane Hookom]

Try a continuous form that is large enough to display two records. Another
alternative is using one or more subforms.

 

[Guest]

If the table has only two records, you could use a continuous form.

 

[Guest]

I am using continuous form and I want to see record 1 and 2 on the same screen,

Current New
COL1 25 36
COL2 0 15
COL3 0 0
ETC

This is what I am looking to do.

 

[Guest]

A continuous form does show multiple record; however, is does not align them
vertically as in your example. It shows them in a horizontal orientation.

If you want to see them in a vertical orientation, you can use two subforms.

 

[Guest]

Thanks

I will also try the sub form method.

Tony