Continious form with new and lasst record on top

[oxicottin]

Hello, I have a continious form thats record source is a table (tbl_MachineOutput) not a query. How can I using VBA have the new record on top and then last record first so I dont have to scroll down the form?

Thanks,

Thanks,
SoggyCashew.....

 

[dhookom]

You can't get the new, blank record to appear at the top. The normal solution is to use a form (never give users table access) with unbound text boxes at the top. When a user completes the text boxes, append the record to the table and requery the form to display all the records with a sort order by the most recent at the top.

Duane
Hook'D on Access
MS Access MVP

 

[oxicottin]

Oh ok I got ya... Thanks!

Thanks,
SoggyCashew.....

 

[TheAceMan1]

How are ya oxicottin . . .

It can be done with a form. See my post [blue]7 Dec 06 8:59[/blue] in thread702-1309854



See Ya . . .

Be sure to see FAQ219-2884 Worthy Reading!
Also FAQ181-2886 Worthy Reading!