Backwards Continous Form

[troix]

How can I make a continous form go backwards? In essence, the new information i enter on top and the "old" goes as 2d so it'll show up backwards of how I put it in?

 

[GingerR]

sort descending on whatever field makes it 'old' or 'new'

 

[luceze]

This is not the answer that you want but you can't change where a new record starts. It is always at the bottom.

Eric

 

[GingerR]

sorry. i wasn't reading it right.

you could do this: make a main form. make a subform with property Data Entry = True that looks like the continuous form, but is only blank row waiting for data entry. then plunk the existing continuous form below this one in the main form.

if you want to, on After Update of the top sub form (the data entry-only one), requery the continuous form below so the newly-entered record goes into it.

Forms!Main!sub.Form.Requery

{sub} is the name of the existing continuous form
Main is the name of the main form

 

[troix]

It will be a subform. If only the "top row" is blank, that would be fine, also. I have to make this as simple for the data entry person as I can.

 

[GingerR]

you could also do this: from a main/switchboard-type form, have one button that says "ADD NEW RECORDS" and one that says "EDIT RECORDS". on click of the first button, open your existing form in data entry mode. on click of the second button, open the existing form in edit mode.