New Record Show First

[Tzokas]

Hello to everyone.

It's a little strange but is there a way to insert (via code or otherwise) a new record on the top of a tabular form instead of inserting it at the bottom? (after all the existing records)

I don't want to make a data entry form...

 

[lupins46]

You can use an unbound data entry area at the top of the form and then add the record to the table in code/sql.

But you can't do anything to change the position of the 'new record' row in a form.

 

[Tzokas]

Thanks lupins46

It is what i had in my mind as the very last solution in case there is no other way.

Finally i'll fix it like that

Thanks again

 

[ZmrAbdulla]

Also you can use bound continues form with
property > data entry=yes
and a listbox down with the records of the same table. Then you can add a List.Requery after exit of the last field. Make the listbox sorting Descending. Keep the data entry area and the list box adjacent & formatting similar to look alike

Zameer Abdulla
[sub]Jack of Visual Basic Programming, Master in Dining & Sleeping[/sub]
Visit Me