moving and adding rows of data

[clmunson]

I have a form with a dozen rows of data in the center of the form. Each row has seven columns: a label and four to six text boxes that display data from a table. I want to insert new rows with similar data at the top of these columns, moving the existing rows down. The form has other information on it. How do I insert the desired rows without moving EVERYTHING on the form down?

[June7]

I don't understand. Are you talking about data entry or form design?

Want to provide db for analysis? Follow instructions at bottom of my post.

[Missinglinq]

...I want to insert new rows with similar data at the top of these columns

...moving the existing rows down.

...How do I insert the desired rows without moving EVERYTHING on the form down?

Sorry, but I understand this even less than June7 does! But putting that confusion aside, for the moment, you appear to want to move the existing rows down but do so without moving EVERYTHING...down? Is it just me, or does this sound like mutually exclusive goals?

Records have no order, in Access Tables, they're like a handful of marbles in a gunny sack! If you want Records to appear in a certain order, you have to set the Form's OrderBy Property using one or more Fields, from the underlying Table/Query, that defines the order.

And to be honest, your explanation of your Form design sounds more than a little wonky! You really need to let us look at your app, if we're to help.

Linq ;0)>

[clmunson]

I know I am not clear. Sorry about that.

My DB is about 500mb, so I am not sure how to give you a concise version with just the form with which I have the question. But perhaps I can play with that and see what I can create. For now, let me give a little more explanation.

I am dealing with form design, not data entry. My form is used to display information from a group of tables. My form has a column of data on the left and some columns to the right. The left-most column of data consists of rows of disparate information displayed in text boxes and labels. It is all regarding an individual. I do not wish to disturb the labels and text boxes in this left-most column. The right group of columns consists of rows of other information about the individual. Each of these rows has a common factor, a year (in a label) and from 4 to 6 text boxes (which read data about that individual in that year from a table). All these are under some column headings (labels). The first row is most recent year is the first row under the column heading; the next row is a previous year, and so on for 12 iterations. What I wish to do is move all these rows down one line, preferably en-mass so that I do not have to reposition each object individually.

Here is a mockup of my form (if this text editor works as I hope it will) -

Right Columns headers:Year Info1 Info2 Info3
LeftLabelA -( Data A ).2011 AA .. BB ...CC
............................... 2010 xx .. yy ... zz
LeftLabel B - (Data B)...2009 kk .. jj .....hh

I need to move the rows of year info down and insert 2012 and build text boxes for its info under the headings.

Does this help??

[June7]

Not much. You have to edit database every year to accommodate the new year's data? Smacks of bad data structure.

You can select all the controls need to move and do so in one action. Just sweep, grab, drag. Unless the controls are 'grouped'. This happens when wizards are used create forms/reports. The 'grouping' can be removed by selecting the affected controls, right click Layout>Remove.