Sort data automatically after adding new record

[Kivan]

Hi,



In my form data is sorted by date (the newest are at top). You can enter new records in that form, the type is continuous form. I would like to know if few things are possible.

1. After you open a form, you always see a list of records and 1 clear record (it is supposed to be a new record). First of all I want this record to be on top, not on the bottom. Secondly, I want to make this empty record to be not visible for user, however if user pushes the "New" button that record should be revealed, to let the user enter new record, then dissapear after entering new record.

2. How to sort data in form automatically after adding new record?

I'm new to access, so if it is possible to this things without VBA It would be great.

Thank you for your time .

[pbaldy]

1) Can't be done natively. The two workarounds I've seen involve either unbound textboxes with a button to add the record, or a data entry subform stacked on top of an existing records subform.

2) The data should resort if you requery the form:

Me.Requery