only in vertical on continuous form?

  • Thread starter Thread starter joanu
  • Start date Start date
J

joanu

Someone can help me please?
I've seen the solution to my problem but i don't know how to implement on
access:

question:
I am trying to find a way that allows me to display a continuous form, but
showing records stacked horizontally
and vertically in a grid, rather than just vertically as the standard
continuous form does. I have a small square form, which I want to fill the
screen, e.g. if there were 20 records, they might appear say in a 5 x 4
grid of squares.

answser:
1)One approach might be to simple have 20 fields on the form. Then loop
through the control values yourself and read/write the records to the
table.
2)Another alternative would be to create a temporary table just before
opening the form with the five fields sideways. If the data already exists
then use some queries to fill the temp table. When the user closes the
form use some queries to write each non null field to a table.

How can i loop through the control values and read/write the records to
the table?
 
It is not quite clear how you want the 2nd set of data to display.

However, usually using a form, and then placing TWO sub-forms on that form
does the trick.

Take a look at the following screen shots of some grids I make in ms-access.

I think you want something like the first one?
 
hello once again

I sent you an email with an image to explain what I'm
trying to do in access.

Thank you
 
Back
Top